mysql5.5字符编码设置,mysql5.5设置字符编码

注：mysql5.5之前的设置字符编码和5.5之后设置字符编码略有不同：

# vi /etc/my.cnf

mysql5.5以下：

在[mysqld]下添加

default-character-set=utf8

在[client]下添加

default-character-set=utf8

mysql 5.5 改为：

[client] default-character-set = utf8 [mysqld] character-set-server = utf8

以下是我使用的mysql5.6的my.conf配置文件：

[client]

default-character-set=utf8

[mysqld]

init_connect=’SET collation_connection = utf8_unicode_ci’

init_connect=’SET NAMES utf8′

character-set-server=utf8

collation-server=utf8_unicode_ci

skip-character-set-client-handshake

key_buffer = 16M

max_allowed_packet = 16M

thread_stack = 192K

thread_cache_size = 8

[mysqld_safe]

basedir=/usr/local/mysql/mysql-5.6.22-linux-glibc2.5-i686

datadir=/usr/local/mysql/mysql-5.6.22-linux-glibc2.5-i686/data

log-error=/usr/local/mysql/mysql-5.6.22-linux-glibc2.5-i686/logs/error.log

innodb_file_per_table=1