mysql 早期版本的表CHARACTER SET默认为utf8mb3,
旧版数据库升级到新版时,
需修改默认的CHARACTER SET,
可用如下的代码生成脚本,再运行脚本:
select concat_ws(’’, ‘ALTER TABLE 库名
.', table_name, '
’
, ’ CHARACTER SET = utf8mb4 , COLLATE = utf8mb4_0900_ai_ci ;’
) cc
from information_schema.tables
where table_schema = ‘库名’ #指定库名
and (table_collation <> ‘utf8mb4_0900_ai_ci’)
order by table_name;