mysql设立中文

前面我们已经说过了，mysql默认的编码是latin1,不是我们所需要的gbk,所以我们要修改成为utf8，因为若要正确显示中文繁、简、日文、韩文?使用utf8，修改方法如下：

??ALTER?DATABASE?sample?####这里修改整个数据库的编码

???????CHARACTER?SET?utf8

???????DEFAULT?CHARACTER?SET?utf8

???????COLLATE?utf8_general_ci

???????DEFAULT?COLLATE?utf8_general_ci;

当然了，你也可在在建数据库的时候指定编码，比如：

CREATE?DATABASE?sample

???????CHARACTER?SET?utf8

???????DEFAULT?CHARACTER?SET?utf8

???????COLLATE?utf8_general_ci

???????DEFAULT?COLLATE?utf8_general_ci?;

接下来要做的是打开mysql所在的目录下的my.nin

在[mysqld]段加入一下代码改成：

default-character-set=utf8

?启动mysql，输入：

执行下列语句，看看结果是不是下面的：

mysql>?show?variables?like?’%character%’;

+————————–+——————————————-+

|?Variable_name????????????|?Value?????????????????????????????????????|

+————————–+——————————————-+

|?character_set_client?????|?latin1????????????????????????????????????|

|?character_set_connection?|?latin1????????????????????????????????????|

|?character_set_database???|?utf8??????????????????????????????????????|

|?character_set_results????|?latin1????????????????????????????????????|

|?character_set_server?????|?utf8?????????????????????????????????????????????????????????????????????????

|?character_set_system?????|?utf8??????????????????????????????????????|

|?character_sets_dir???????|?C:\MySQL\MySQL?Server?5.0\share\charsets\?|

+————————–+——————————————-+

mysql>?show?variables?like?’%collation%’;

+———————-+——————-+

|?Variable_name????????|?Value?????????????|

+———————-+——————-+

|?collation_connection?|?latin1_swedish_ci?|

|?collation_database???|?utf8_general_ci???|

|?collation_server?????|?utf8_general_ci???|

+———————-+——————-+

?