mysql字符集查看以及修改
/usr/share/mysql/my-large.cnf
/usr/share/mysql/my-small.cnf
/usr/share/mysql/my-medium.cnf
/usr/share/mysql/my-huge.cnf
/usr/share/texmf/web2c/texmf.cnf
/usr/share/texmf/web2c/mktex.cnf
/usr/share/texmf/web2c/fmtutil.cnf
/usr/share/texmf/tex/xmltex/xmltexfmtutil.cnf
/usr/share/texmf/tex/jadetex/jadefmtutil.cnf
/usr/share/doc/MySQL-server-community-5.1.22/my-innodb-heavy-4G.cnf
/usr/share/doc/MySQL-server-community-5.1.22/my-large.cnf
/usr/share/doc/MySQL-server-community-5.1.22/my-small.cnf
/usr/share/doc/MySQL-server-community-5.1.22/my-medium.cnf
/usr/share/doc/MySQL-server-community-5.1.22/my-huge.cnf2. 拷贝 small.cnf、my-medium.cnf、my-huge.cnf、my-innodb-heavy-4G.cnf其中的一个到/etc下，命名为my.cnfcp /usr/share/mysql/my-medium.cnf /etc/my.cnf
3. 修改my.cnf
vi /etc/my.cnf
在[client]下添加default-character-set=utf8
在[mysqld]下添加default-character-set=utf8
4.重新启动MySQL
[root@bogon~]#/etc/rc.d/init.d/mysqlrestart
ShuttingdownMySQL[确定]
StartingMySQL.[确定]
[root@bogon~]#mysql-uroot-p
Enterpassword:
WelcometotheMySQLmonitor.Commandsendwith;or/g.
YourMySQLconnectionidis1
Server version: 5.1.22-rc-community-log MySQL Community Edition (GPL)Type 'help;' or '/h' for help. Type '/c' to clear the buffer.
5.查看字符集设置
mysql> show variables like 'collation_%';
+----------------------+-----------------+
|Variable_name|Value|
+----------------------+-----------------+
|collation_connection|utf8_general_ci|
|collation_database|utf8_general_ci|
|collation_server|utf8_general_ci|
+----------------------+-----------------+
3 rows in set (0.02 sec)mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
|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|/usr/share/mysql/charsets/|
+--------------------------+----------------------------+
8 rows in set (0.02 sec)mysql>
通过配置文件修改:
修改/var/lib/mysql/mydb/db.opt
default-character-set=latin1
default-collation=latin1_swedish_ci
为
default-character-set=utf8
default-collation=utf8_general_ci重起MySQL: [root@bogon ~]# /etc/rc.d/init.d/mysql restart
通过MySQL命令行修改:
mysql> set character_set_client=utf8;Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_connection=utf8;Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_database=utf8;Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_results=utf8;Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_server=utf8;Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_system=utf8;Query OK, 0 rows affected (0.01 sec)
mysql> set collation_connection=utf8;Query OK, 0 rows affected (0.01 sec)
mysql> set collation_database=utf8;Query OK, 0 rows affected (0.01 sec)
mysql> set collation_server=utf8;Query OK, 0 rows affected (0.01 sec)
查看:
mysql>showvariableslike'character_set_%';
+--------------------------+----------------------------+
|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|/usr/share/mysql/charsets/|
+--------------------------+----------------------------+
8 rows in set (0.03 sec)mysql> show variables like 'collation_%';
+----------------------+-----------------+
|Variable_name|Value|
+----------------------+-----------------+
|collation_connection|utf8_general_ci|
|collation_database|utf8_general_ci|
|collation_server|utf8_general_ci|
+----------------------+-----------------+
3 rows in set (0.04 sec)(cs870101)