The default encoding in mysql is latin1 (ISO_8859_1), which can be viewed using the "SHOW VARIABLES LIKE 'character%';" command. latin1 encoding is a single-byte encoding, backward compatible with ASCII, but does not support Chinese. You can modify the default encoding by searching and setting the values of the "default-character-set" and "character_set_server" items in the configuration file "my.ini" .
The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.
MySQL default character set
MySQL’s character set specification can be refined to a database, a table, and a column. What character set should be used. However, traditional programs do not use such complex configurations when creating databases and data tables. They use default configurations. So, where does the default configuration come from?
When compiling MySQL, a default character set is specified, which is latin1;
By default, the character set of mysql is latin1 (ISO_8859_1).
ISO-8859-1 encoding is a single-byte encoding and is backward compatible with ASCII. Chinese encoding is not supported. If you do not explicitly specify the encoding method when creating a database or table, the database will use the default encoding method, and then when you insert Chinese data, garbled characters will appear
How to check the default character set
Usually, you can use the following two commands to check the system character set and sorting settings:
SHOW VARIABLES LIKE 'character%';
SHOW VARIABLES LIKE 'collation_%';
#Modify the method of modifying the default character set
The default encoding of MySQL is Latin1, which does not support Chinese, so how to modify MySQL The default encoding of client] and [mysqld], add
default-character-set=utf8, save and close (if an error occurs after adding in mysqld, you can try
character-set-server=utf8) <div class="code" style="position:relative; padding:0px; margin:0px;"><pre class="brush:php;toolbar:false">default-character-set = utf8
character_set_server = utf8</pre><div class="contentsignin">Copy after login</div></div>3. Restart the MySQL service<code>
[Related recommendations: mysql video tutorial
]
The above is the detailed content of What is the default encoding of mysql. For more information, please follow other related articles on the PHP Chinese website!