Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to solve the Mysql 3.0 to Mysql 5.0 character set problem, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

Mysql 3.0 does not have character set settings when creating object databases and tables. At present, most of us have upgraded the data to the latest version related to Mysql 5.0. The most common problem in the process of importing the library is the character set problem.

Solution:

1. Normal dump complete database files on Mysql 3.0, such as test_db.sql

two。 Create a database on Mysql 5.0.

a. Character set is gb2312

Mysql > CREATE DATABASE test_db DEFAULT CHARACTER SET gb2312 COLLATE gb2312_chinese_ci

b. Character set is gbk

Mysql > CREATE DATABASE test_db DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci

c.

Mysql > CREATE DATABASE test_db DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

3. Import test_db.sql normally

View table character set types

Mysql > use test_db

Mysql > show table status

Thank you for reading this article carefully. I hope the article "how to solve the character set problem of Mysql 3.0 to Mysql 5.0" shared by the editor will be helpful to everyone. At the same time, I hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.