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

This article mainly explains "how to solve Mysql garbled problem", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let Xiaobian take you to learn "how to solve Mysql garbled code problem"!

The system is Fedora15. After sudo yum install mysql-server mysql-client, modify/etc/my.cnf

Add default-character-set=utf8 under [mysqld], restart mysql, find error, check log,

Knowing that default-character-set configuration items are not recognized, cups, ah, online search, are using this method ah!

Because I know from mysql> show variables like 'character %'; that only character_set_server is not utf8,

So I looked for this on the Internet. Finally, I accidentally saw in an article that some netizens added: character_set_server=utf8 under [mysqld].

Only then did he realize!

In addition, other character set changes for other items are similar to the above.

Here are the commands to modify, table, and field codes:

alter database databasename character set utf8;

alter table tablename convert to character set utf8;

alter table `tablename` change `colname` `colname` varchar(200) character set utf8 not null;

At this point, I believe that everyone has a deeper understanding of "how to solve Mysql garbled code problems," may wish to actually operate it! Here is the website, more related content can enter the relevant channels for inquiry, pay attention to us, continue 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.