Create a new table or database each time , When inserting Chinese, either 1366 error , Or insert it and find out that all the Chinese characters have become Chinese ??? After modifying the character set , Reopen the database next time , It will be restored to the original character set .
resolvent :
find mysql Under the installation directory of my.ini configuration file , I found that I had stored the configuration file as a text document , It's like ***. I found one on the Internet my.ini Template for configuration file , Just add it in .
character
After modification , Open database ( If not, restart the computer and try ) The query character set is .
±-------------------------±-----------------------------------------------+
| Variable_name | Value |
±-------------------------±-----------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | E:\MySQL11\mysql-5.7.25-winx64\share\charsets\ |
±-------------------------±-----------------------------------------------+

Technology
©2019-2020 Toolsou All rights reserved,
java Four functional interfaces ( a key , simple ) It's unexpected Python Cherry tree (turtle The gorgeous style of Library ) Browser kernel ( understand )HashMap Explain in detail Some East 14 Pay change 16 salary , Sincerity or routine ?html Writing about cherry trees , Writing about cherry trees