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

The following mainly brings you the playbook of setting the mysql character set. I hope these contents can bring you practical use, which is also the main purpose of this article that I edit the mysql character set. All right, don't talk too much nonsense, let's just read the following.

Configuration file path: / full/path/mysql/bin/my.cnf (default is / etc/my.cnf)

[client]

Default-character-set=utf8

[mysql]

Default-character-set=utf8

[mysqld]

Init_connect='SET collation_connection = utf8_unicode_ci'

Init_connect='SET NAMES utf8'

Character-set-server=utf8

Collation-server=utf8_unicode_ci

Skip-character-set-client-handshake

View mysql encoding method

Show variables like 'character%'

Where character_set_client is the client-side coding method

The encoding used by character_set_connection to establish a connection

Coding of character_set_database database

Coding of character_set_results result set

Coding of character_set_server database CVM

As long as the above four adopt the same coding method, there will be no garbled problem.

For the above about setting up the mysql character set strategy, we do not think it is very helpful. If you need to know more, please continue to follow our industry information. I'm sure you'll like it.

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.