mysql默认字符集能否进行修改呢?答案是肯定的,下面就将教您两种修改mysql默认字符集的方法,希望对您学习mysql默认字符集方面能有所启迪。
1. 修改f
vi /etc/f
在[client]下添加
default-character-set=utf8
在[mysqld]下添加
default-character-set=utf8
2.重新启动MySQL
[root@bogon ~]# /etc/rc.d/init.d/mysql restart
Shutting down MySQL [ 确定 ]
Starting MySQL.[ 确定 ]
使用 mysql> SHOW VARIABLES LIKE 'character%';查看,发现数据库编码均已改成utf8
+--------------------------+---------------------------------+ |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"| +--------------------------+---------------------------------+
(2) 还有一种修改mysql默认字符集的方法,就是使用mysql的命令
mysql>SETcharacter_set_client=utf8; mysql>SETcharacter_set_connection=utf8; mysql>SETcharacter_set_database=utf8; mysql>SETcharacter_set_results=utf8; mysql>SETcharacter_set_server=utf8; mysql>SETcollation_connection=utf8; mysql>SETcollation_database=utf8; mysql>SETcollation_server=utf8;
一般就算设置了表的mysql默认字符集为utf8并且通过UTF-8编码发送查询,你会发现存入数据库的仍然是乱码。问题就出在这个connection连接层上。解决方法是在发送查询前执行一下下面这句:
SETNAMES'utf8';
它相当于下面的三句指令:
SETcharacter_set_client=utf8; SETcharacter_set_results=utf8; SETcharacter_set_connection=utf8;