The Chinese garbled solution in MySQL database.

The database input Chinese is easy to appear garbled? (garbled problem Source: seehttp://blog.51cto.com/12042068/2115021)

WORKAROUND: 1. Specify the default encoding UTF8 when building the table.

                CREATE TABLE table_name (column_name Column_type) default Charset=utf8;(note ";" The previous section. Clearly defined character set)

        2.2 parameter comparison to explain the different client garbled solution:

Focus on two parameters first:character_set_client and character_set_results

The following are the comparison of encoding formats under the MySQL character window and dbeaver, respectively:

v S

Here the meaning of the parameter:

See below for 2 revised: effect at a glance

Garbled problem, generally so find the source. Break it one by one. Come on.

The Chinese garbled solution in MySQL database.