使用MySQL时,是否遇到数据库中存储的值是乱码的?我就遇到过这种情况,经过分析,是MySQL服务端字符集的问题,下面我通过5个步骤,告诉大家如何修改字符集:

1、登陆数据库

jm_csminf2:/usr/local/mysql/bin# ./mysql -uroot -pEnter password: system

mysql> show variables like 'collation_%';+----------------------+-------------------+| Variable_name | Value |+----------------------+-------------------+| collation_connection | latin1_swedish_ci || collation_database | latin1_swedish_ci || collation_server | latin1_swedish_ci |+----------------------+-------------------+3 rows in set (0.00 sec)

1）在[client]下添加

default-character-set=utf8

2）在[mysqld]下添加

default-character-set=utf8

1）停mysql

jm_csminf2:/usr/local/mysql/bin# ./mysqladmin -u root -p shutdownEnter password:jm_csminf2:/usr/local/mysql/bin#

2）起mysql

# /usr/local/mysql/bin/mysqld_safe &

jm_csminf2:/usr/local/mysql/bin# ./mysql -uroot -pEnter password:mysql> show variables like 'collation_%';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.00 sec)

经验证，表属性值乱码问题解决。

希望对大家有用，经常做笔记是个好习惯，自己需要时查一下，别人需要时也可以参考，利人利己。后续我会将我遇到的问题整理成文章，希望对大家有用。