mysql 5.6 字符集_[mysql]mysql-5.6字符集设置

环境：mysql-5.6.22-winx64

复制文件my-default.ini，重命名为my.ini

添加内容如下：

[client]

# Client characterset and Connection characterset

default-character-set=utf8

[mysqld]

# Server characterset and Database characterset

character_set_server=utf8查看状态

mysql> status

--------------

mysql Ver 14.14 Distrib 5.6.22, for Win64 (x86_64)

Connection id: 1

Current database:

Current user: root@localhost

SSL: Not in use

Using delimiter: ;

Server version: 5.6.22 MySQL Community Server (GPL)

Protocol version: 10

Connection: localhost via TCP/IP

Server characterset: utf8

Db characterset: utf8

Client characterset: utf8

Conn. characterset: utf8

TCP port: 3306

Uptime: 8 sec查看字符集：

SHOW VARIABLES LIKE 'collation%';

SHOW VARIABLES LIKE 'character_set%';