Change MySQL default character set to UTF-8 in my.cnf?
来源:互联网 发布:故事板软件下载 编辑:程序博客网 时间:2024/05/21 21:01
注: mysql 5.5.40-0ubuntu0.14.04.1 (Ubuntu) 可以按此修改编码。
For the recent version of MySQL,
default-character-set = utf8
causes a problem. It's deprecated I think.
As Justin Ball says in "Upgrade to MySQL 5.5.12 and now MySQL won’t start , you should:
Remove that directive and you should be good.
Then your configuration file ('/etc/my.cnf' for example) should look like that:
[mysqld]collation-server = utf8_unicode_ciinit-connect='SET NAMES utf8'character-set-server = utf8
Restart MySQL.
For making sure, your MySQL is UTF-8, run the following queries in your MySQL prompt:
First query:
mysql> show variables like 'char%';
The output should look like:
+--------------------------+---------------------------------+ | 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/local/mysql/share/charsets/| +--------------------------+---------------------------------+
Second query:
mysql> show variables like 'collation%';
And the query output is:
+----------------------+-----------------+ | Variable_name | Value | +----------------------+-----------------+ | collation_connection | utf8_general_ci | | collation_database | utf8_unicode_ci | | collation_server | utf8_unicode_ci | +----------------------+-----------------+
0 0
- Change MySQL default character set to UTF-8 in my.cnf?
- default-character-set=utf-8 mysql解决中文乱码问题
- mysql中通过my.cnf设置默认字符集utf-8
- Change Column Name or Set Default Value in MySql
- Change MySql Database character set
- Mysql中文乱码问题完美解决方案【需要在my.cnf文件中设置client和mysqld的default-character-set=utf8,建数据库和表的时候也需要制定好编码】
- How to change mysql default data directory in Ubuntu
- How to Change default MySQL Data Directory in Linux111
- MYSQL数据插入 乱码问题 default-character-set=latin1改成default-character-set=utf8 在my.ini文件中。需要改动两处
- mac mysql 命令行修改 character无效 配置文件my.cnf
- mac终端下修改MySQL的编码格式--找不到my-default.cnf及my.cnf
- MySQL的my.cnf文件(解决5.7.18下没有my-default.cnf)
- MySQL数据库的default-character-set问题
- Linux下安装mysql5.7缺少my-default.cnf文件及Can't connect to local MySQL server 解决方案
- comment set character in mysql
- mysql通过my.cnf修改默认字符集为utf-8的方法以及注意事项
- change eclipse default text encoding to UTF-8 to support php i18n
- MySQL 5.5版本下my.ini内[mysqld]项中不能再写default-character-set=utf8
- iOS中枚举的使用
- android 键盘监听EditView时,自定义键盘的确定按钮样式
- MagicalRecord的使用
- Android动态部署一:Google原生Split APK浅析
- 人机大战直播:新媒体KO广电系(来源:中广互联)
- Change MySQL default character set to UTF-8 in my.cnf?
- Android绘制文字
- ANT搜索
- IntelliJ IDEA 简体中文专题教程
- Hibernate之SQL检索(查询)方式
- Android特效 五种Toast详解
- JSP与Servlet之间传值
- 系统调用执行过程
- 数据库设计原则