Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

The method of modifying utf8 by mysql

2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

How does mysql modify utf8? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

Mysql's way to modify utf8: first, check the mysql character set through "show variables like 'character_set_%';"; then find the my.ini file in the mysql installation directory and modify it; finally, restart mysql.

Mysql version 5.7 changed the code to utf-8

Just started to learn mysql, downloaded is the latest version of the official website 5. 7.14, using cmd to enter Chinese Times error, so began to modify the mysql default code (under windows)

First check the mysql character set through show variables like 'character_set_%';

The default encoding is latin1

Then shut down the database.

Find the my.ini file in the mysql installation directory

Add to it

[client] default-character-set=utf8

Add under [mysqld]

Character-set-server=utf8

Restart mysql

You can change the default encoding of mysql database to utf-8.

Many resources on the Internet are added under [mysqld].

Default-character-set=utf8

If this is changed, version 5.7 mysql will not be opened.

So it has to be changed to

Character-set-server=utf8, thank you for your reading! After reading the above, do you have a general understanding of mysql's method of modifying utf8? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report