如何转换latin1_swedish_ci数据到utf8_general_ci？ [英] How to convert latin1_swedish_ci data into utf8_general_ci?

问题描述

我有一个MySQL数据库，所有表字段排序为

I have a MySQL database with all the table fields collation as

latin1_swedish_ci

它已经存储了近1000条记录，现在我想将所有这些数据转换成

It has almost 1000 of the records already stored and now I want to convert all these data into

utf8_general_ci

。我已将字段排序规则更改为 utf8_general_ci ，但这并不会将所有旧记录 CONVERT 修改为 utf8_general_ci

So that I can display any language content. I have already altered the field collations into utf8_general_ci but this does not CONVERT all the old records into utf8_general_ci

推荐答案

使用它将现有的MySQL数据库从一个字符集编码转换为另一个

Use this to convert existing MySQL database from one charset encoding to another

ALTER DATABASE db_name DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

将现有表格从一个字符集编码转换为另一个

Convert existing table from one charset encoding to another

ALTER TABLE db_table CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

CONVERT（）集。检查此以供参考

这篇关于如何转换latin1_swedish_ci数据到utf8_general_ci？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！