MYSQL中文乱码.doc

MYSQL 两个男人追一个女人用情浅的会先放弃。两个女人追一个男人用情深的会先放弃。╰︶￣—你的话, 我连标点符号都不信男女授受不亲, 中国哪来 13 亿人口。 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show character ->; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 mysql> SHOW VARIABLES LIKE 'character_set_%'; +--------------------------+---------------------------------------+ | Variable_name | Value | +--------------------------+---------------------------------------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | gbk| | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | gbk| | character_set_system | utf8 | | character_sets_dir | D:\PC_webserver\mysql\share\charsets\ | +--------------------------+---------------------------------------+ 8 rows in set ( sec) mysql> SHOW VARIABLES LIKE 'collation_%'; +----------------------+-------------------+ | Variable_name | Value | +----------------------+-------------------+ | collation_connection | latin1_swedish_ci | | collation_database | gbk_chinese_ci | | collation_server | gbk_chinese_ci | +----------------------+-------------------+ 3 rows in set ( sec) mysql> set collation_connection =gbk; ERROR 1273 (HY000): Unknown collation: 'gbk' mysql> set coll