mysql5.7字元集問題

[client]

port = 3306 

socket = /home/mysql/socket/mysql.sock 

[mysqld]

port = 3306

skip-grant-tables = 1

character_set_server = utf8

字元集改變

mysql> show variables like '%char%';

+--------------------------+----------------------------+

| Variable_name | Value |

| character_set_client | utf8 |

| character_set_connection | utf8 |

| character_set_database | utf8 |

| character_set_filesystem | binary |

| character_set_results | utf8 |

| character_set_server | utf8 |

| character_set_system | utf8 |

| character_sets_dir | /usr/share/mysql/charsets/ |

8 rows in set (0.01 sec)

mysql>

本文轉自 小小三郎1 51CTO部落格，原文連結：http://blog.51cto.com/wsxxsl/2049004，如需轉載請自行聯系原作者