本文共 1031 字,大约阅读时间需要 3 分钟。
查询:
1.使用mysql> show variables like 'collation_%'; +----------------------+-----------------+ | Variable_name | Value | +----------------------+-----------------+ | collation_connection | utf8_general_ci | | collation_database | utf8_general_ci | | collation_server | utf8_general_ci |+----------------------+-----------------+
2.使用 mysql> SHOW VARIABLES LIKE 'character%';查看, +--------------------------+---------------------------------+ | 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 | D:"mysql-5.0.37"share"charsets" | +--------------------------+---------------------------------+ 如果不一致,修改mysql的my.ini文件中的字符集键值, default-character-set = utf8
character_set_server = utf8
在mysql中输入命令修改有时会无效,最好是修改my.ini!!!!!!!!!!!!!!!
转载地址:http://kjhgi.baihongyu.com/