MySQL 编码

)、ALTER TABLE tbl_name [DEFAULT] CHARACTER SET [=] charset_name [COLLATE [=] collation_name] 2)、ALTER TABLE tbl_name CONVERT TO CHARACTER SET charset_name [COLLATE collation_name]

修改数据库编码

 ALTER DATABASE db_name [DEFAULT] CHARACTER SET [=] charset_name

创建数据库时指定

CREATE DATABASE db_name [DEFAULT] CHARACTER SET [=] charset_name

创建表时指定

CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name(col_name create_definition,...)[DEFAULT] CHARACTER SET [=] character_name

 

MySQL 编码

标签：exist   efault   配置   char   style   init   set   database   目录