扬帆科技—专业的Linux服务器代维护

更改mysql数据库编码

作者：linux120 发布时间：April 2, 2014 分类：服务器维护

修改字段编码:

ALTER TABLE artists
CHANGE [fieldname] [fieldname] [fieldtype]
CHARACTER SET [encoding]Change MySQL Database Encoding
COLLATE [collation];
修改表编码:

ALTER TABLE [tablename]
CONVERT TO CHARACTER SET [encoding]
COLLATE [collation];
修改数据库编码:

ALTER DATABASE [dbname]
CHARACTER SET [encoding]
COLLATE [collation];

标签: none