How to modify the MySQL default character set: MySQL default encoding is Latin1, does not support Chinese, should be set to UTF8 to see if their database encoding is set.
(0)
1. If the MySQL installation directory, there is a suffix named:. ini configuration file, copy, modify to My.ini
2. If there is no. ini file in the MySQL installation directory, create a plain TXT file that is modified to: My.ini (note that you should see. txt before you modify it)
3. Modify the configuration file as follows:
[Client]
Default-character-set=UTF8
[mysqld]
Character-set-Server=UTF8
[MySQL]
Default-character-set=UTF8
(1)
Another way to modify the MySQL default character set is to use the MySQL command
- MySQL> SET character_set_client = UTF8;
- MySQL> SET character_set_connection = UTF8;
- MySQL> SET character_set_database = UTF8;
- MySQL> SET character_set_results = UTF8;
- MySQL> SET character_set_server = UTF8;
- MySQL> SET collation_connection = UTF8;
- MySQL> SET collation_database = UTF8;
- MySQL> SET collation_server = utf8;
In general, even if you set the table MySQL default character set is UTF8 and send the query through UTF-8 encoding, you will find that the database is still garbled. The problem is on the connection connection layer. The workaround is to execute the following sentence before sending the query:
- SET NAMES ' UTF8 ';
It is equivalent to the following three-sentence instruction:
- SET character_set_client = UTF8;
- SET character_set_results = UTF8;
- SET character_set_connection = UTF8;
MySQL Character set
The database system--and the database--and the table--fields can set the character set, and if subordinates each specify, use the parent's
If the table uses UTF-8 storage file, it must be UTF-8
connection is analogous to a character converter that is responsible for translating client-side writes with database encoding, as well as for database and return views.
(client------>connection--->database) (database-->connection-->result)
MYSQL Character Set