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

Editor to share with you how to set up phpmyadmin utf_8, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to understand it!

1. Phpmyadmin sets the default encoding of the newly-built database to utf8 encoding.

1. Create a new database my_db

2. Use SQL statement

Set character_set_server=utf8; / / sets the default new database encoding to utf8

Alter database testdb character set utf8; / / change existing database encoding

Second, the setting of gbk or utf8 code when phpmyadmin is imported into the database (to solve the problem of garbled codes in the imported database)

1. First of all, make sure that the Chinese in the imported sql file is not garbled. The sql file can be encoded by utf8 or gb2312. It doesn't matter.

2, at the beginning of the sql file to add set names utf8 or gb2312; (must be the same as your file encoding, if you want to import is utf8, your file encoding is utf8, if you want to import is gbk/gb2312, your file encoding is gbk/gb2312).

3. You can import directly through the phpmyadmin import interface.

Third, click modify in the data table of phpmyadmin, and then modify the collation to set utf_8.

The above is all the contents of the article "how to set up utf_8 in phpmyadmin". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, 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.