????mysql ???? ???????????????????????????????????????????????????????????????????????????????????????????????????

?????????????????UTF8???????????????latin ????????????????????????????UTF8?????????????????????????????????????????????????

????????????????????????????κ????????????????????

?????????????????????????????

????mysql> SHOW VARIABLES LIKE 'character%';

????????????????? latin1???????????????′??????????latin1???UTF8?????

?????????Σ?

????mysql???????????

SET character_set_client = utf8;
SET character_set_connection = utf8;
SET character_set_database = utf8;
SET character_set_results = utf8;
SET character_set_server = utf8;

??????? mysql> SHOW VARIABLES LIKE 'character%'; ???????????? utf8 ??

????????????????????

?????????????????????Ч??????????????????Ч??

??????????????????????????????my.ini?????

??????my.ini????????????е??????е?????

????[client]
????default-character-set=utf8
????[mysql]
????default-character-set=utf8
????[mysqld]
????default-character-set=utf8

????????3??section?????default-character-set=utf8????????????????mysqld??

???????????mysql?????

????mysql> SHOW VARIABLES LIKE 'character%';

??????????е?Value????utf8???ɡ?

??????????????????????

????|character_set_client      | utf8                                  |
????| character_set_connection | utf8                                  |
????| character_set_database   | utf8                                  |
????| character_set_filesystem | binary                                |
????| character_set_results    | utf8                                  |
????| character_set_server     | latin1                                |
????| character_set_system     | utf8

???????  ??????| character_set_server     | latin1 ??????ó?UTF8   ???????????????????