mysql修改utf 8_如何设置mysql数据库为utf-8编码

创建一个UTF-8 编码的数据库

MySQL

Create a UTF-8 database with binary UTF-8 collation.

Binary UTF-8 provides case-sensitive collation.

CREATE DATABASE confluence CHARACTER SET utf8 COLLATE utf8_bin;

You will also need to set the Server Characterset to utf8. This can be done by adding the following in my.ini for Windows or my.cnf for other OS. It has to be declared in the Server section, which is the section after [mysqld]:

[mysqld]

default-character-set=utf8

Use the status command to verify database character encoding information.

    Screenshot: Using the Status Command to Verify Database Character Encoding