解决方案如下:
-- 修改表字段注解和表注解
alter table COLUMNS_V2 modify column COMMENT varchar(256) character set utf8;
alter table TABLE_PARAMS modify column PARAM_VALUE varchar(4000) character set utf8;
-- 修改分区字段注解
alter table PARTITION_PARAMS modify column PARAM_VALUE varchar(4000) character set utf8;
alter table PARTITION_KEYS modify column PKEY_COMMENT varchar(4000) character set utf8;
-- 修改索引注解
alter table INDEX_PARAMS modify column PARAM_VALUE varchar(4000) character set utf8;
-- 修改表试图
alter table TBLS modify column VIEW_EXPANDED_TEXT mediumtext character set utf8;
alter table TBLS modify column VIEW_ORIGINAL_TEXT mediumtext character set utf8;
Mysql中文乱码解决方案
最新推荐文章于 2024-04-25 12:02:52 发布