1.查看mysql的字符集
mysql> SHOW CHARACTER SET;
+----------+-----------------------------+---------------------+--------+
| Charset
+----------+-----------------------------+---------------------+--------+
| big5
| dec8
| cp850 | DOS West European
| hp8
| koi8r | KOI8-R Relcom Russian
| latin1 | cp1252 West European
| latin2 | ISO 8859-2 Central European | latin2_general_ci | 1
| swe7
| ascii | US ASCII
| ujis
| sjis
| hebrew | ISO 8859-8 Hebrew
| tis620 | TIS620 Thai
| euckr | EUC-KR Korean
| koi8u | KOI8-U Ukrainian
| gb2312 | GB2312 Simplified Chinese | gb2312_chinese_ci | 2
| greek | ISO 8859-7 Greek
| cp1250 | Windows Central European | cp1250_general_ci | 1
| gbk
| latin5 | ISO 8859-9 Turkish
| armscii8 | ARMSCII-8 Armenian
| utf8
| ucs2
| cp866 | DOS Russian
| keybcs2
| macce | Mac Central European
| macroman | Mac West European
| cp852 | DOS Central European
| latin7 | ISO 8859-13 Baltic
| cp1251 | Windows Cyrillic
| cp1256 | Windows Arabic
| cp1257 | Windows Baltic
| binary | Binary pseudo charset
| geostd8
| cp932 | SJIS for Windows Japanese | cp932_japanese_ci | 2
| eucjpms
+----------+-----------------------------+---------------------+--------+
36 rows in set (0.02 sec)
2.查看系统的字符集和排序方式的设定可以通过下面的两条命令:
mysql> SHOW VARIABLES LIKE 'character_set_%';
+--------------------------+-------------------------------------------+
| Variable_name
+--------------------------+-------------------------------------------+
| character_set_client
| character_set_connection | latin1
| character_set_database | latin1
| character_set_filesystem | binary
| character_set_results | latin1
| character_set_server
| character_set_system
| character_sets_dir
+--------------------------+-------------------------------------------+
8 rows in set (0.06 sec)
mysql> SHOW VARIABLES LIKE 'collation_%';
+----------------------+-------------------+
| Variable_name
+----------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server
+----------------------+-------------------+
3 rows in set (0.02 sec)
3.修改数据库字符集
alter database