以下均在mysql 5.5命令行中運行通過：

查看MySQL支持的字符集：

復制代碼 代碼如下:

show charset;

復制代碼 代碼如下:

status

復制代碼 代碼如下:

SHOW VARIABLES LIKE 'character_set_%';

復制代碼 代碼如下:

SHOW VARIABLES LIKE 'collation_%';

復制代碼 代碼如下:

CREATE DATABASE [db-name] CHARACTER SET utf8 COLLATE utf8_general_ci;

復制代碼 代碼如下:

create table [table-name] (id int not null ) default charset utf8;

復制代碼 代碼如下:

show create database [db-name];

復制代碼 代碼如下:

show create table [table-name];

復制代碼 代碼如下:

show table status from [db-name];

復制代碼 代碼如下:

show table status from [db-name] like '%filter%';

復制代碼 代碼如下:

show full columns from [table-name];

復制代碼 代碼如下:

show table status from [db-name];

復制代碼 代碼如下:

ALTER DATABASE [db-name] DEFAULT CHARACTER SET [character-name] COLLATE [collation-name];

復制代碼 代碼如下:

ALTER TABLE [table-name] CONVERT TO CHARACTER SET [character-name] COLLATE [collation-name];

復制代碼 代碼如下:

ALTER TABLE [table-name] DEFAULT CHARACTER SET [character-name] COLLATE [collation-name];

復制代碼 代碼如下:

SET NAMES 'utf8';