MySQL insertion garbled problem

Reason:

The character encoding of the database table and insert statement does not match or the encoding of the database table does not support Chinese

Solution:

Modify the character encoding in the table to: Utf-8 (or gbk,gb2312)

When you link a database in code, the connection string is followed by a characterencoding=utf8, such as Jdbc:mysql://localhost:3306/db_zhu?characterencoding=utf8

When the insertion or modification occurs garbled, first in the MySQL terminal execution under the INSERT statement, check whether the insertion is correct. Then in the code to print the next INSERT statement, see if there is garbled or question mark? See if the connection string is set to Characterencoding

Report:

Wamp requires mysql-u root to have root access when executing MySQL terminal.

Expand:

Http://www.cnblogs.com/hongfei/archive/2011/12/29/set-names-utf8.html

MySQL insertion garbled problem