MySQL garbled solution

MySQL supports dozens of encoding methods, and the default encoding is: LATINL, if MySQL garbled situation, do not panic, to introduce you two ways to solve the encoding:

In the console input command, note that the MySQL UTF-8 written in utf8, for example I now have a database name of: Lcychina, set as follows:

mysql> ALTER DATABASE Lcychina character set UTF8;
Query OK, 1 row affected

Mysql>

View the current database encoding command as:

Mysql> Show variables like ' character_set_database ';
+------------------------+-------+
| variable_name | Value |
+------------------------+-------+
| Character_set_database | UTF8 |
+------------------------+-------+
1 row in Set

Modify the My.ini configuration file, open it with Notepad, locate the MySQL installation directory, and the path to my MySQL installation is: D:\Java\MySQL\MySQL Server 5.5

Looks like 57 rows. Found: Default-character-set=latinl

Modified to: Default-character-set=utf8

There should be two lines of code like this, and note that modifying parameters only affects future databases or tables. does not affect databases and tables that already exist.

MySQL garbled solution