通过Django的admin后台管理来更新数据
(1) 采用Django自带的SQLite3数据库存储中文没有任何问题
(2) 采用MySQL数据库做同样的事情时问题就来了,通过admin后台来更新含有中文的数据时出现:
进入MySQL,在shell下输入 show variables like "character%";
或者输入statue来查看,可知编码默认是Latin1
解决办法是:
找到MySQL安装目录下的my.ini配置文件,进行如下的修改(加粗字体是需要修改或者增加的)
[client]
port=3306
default-character-set=utf8
[mysql]
default-character-set=utf8
# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this
# file.
#
[mysqld]
# The TCP/IP Port the MySQL Server will listen on
port=3306
default-character-set=utf8
#Path to installation directory. All paths are usually resolved relative to this.
basedir="D:/MySQL Server 5.0/"
#Path to the database root
datadir="D:/MySQL Server 5.0/Data/"
# The default character set that will be used when a new schema or table is
# created and no character set is defined
character-set-server=utf8
网上也有说法是在[mysqld]和[client]两个标签下都加入 default_character_set = utf8
然后输入net stop mysql ,关闭MySQL
再重新启动MySQL,net start mysql
删除掉之前已经建立起的database
然后重新建立一个新的database
再然后manage.py syncdb 同步数据库
这样之后,进入admin后台管理(需要用到之前同步数据库时让输入的用户名和密码来登录),这时再添加含有中文的数据就没有问题啦
进入MySQL,去查看下编码,如下:
可以看到database和server的character_set发生了改变,由之前的Latin1变成了utf8