mysql修改编码_MySQL

bitsCN.com

• 修改表编码
• ALTER TABLE  `uc_users_bak` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
• #检查数据表所有字段的状态
• ->show full columns from phplamp;
• #发现address字段的Collation项非utf8，修改它！
• ->alter table phplamp change name name varchar(100) character set utf8 collate utf8_unicode_ci not null default '';

bitsCN.com