Mysql Default encoding for UTF-8 by modifying the my. ini implementation method, utf-8my.ini

Mysql Default encoding for UTF-8 by modifying the my. ini implementation method, utf-8my.ini

Why mysql Chinese characters are garbled

Mysql Default encoding is Latin1 is the alias of the I-8859-1, but Latin1 does not support Chinese characters, so you need to change it to UTF-8 or GBK

1. Shut down the mysql server. This is very important.

2. Use my. ini to set the mysql database encoding.

Find my. ini in the root directory of mysql database installation, for example, C: \ Program Files \ MySQL Server 5.5

Copy it to the desktop and double-click it,

Search "default-character-set" and change it to utf8,

Search for "character-set-server = utf8" and change it to utf8.

Check that the modification is successfully saved. Copy my. ini back to C: \ Program Files \ MySQL Server 5.5 and start the mysql Server!

Thank you for reading this article. I hope it will help you. Thank you for your support for this site!