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