Java write MySQL Chinese garbled problem (fix)

2. To create a database:

   CREATE DATABASE ' Db ' CHARACTER SET ' utf8 ' COLLATE ' utf8_general_ci ';

3. 2

   When building a table:

    CREATE   TABLE    ' TableA '     (                                        ' ID '     varchar (+)    NOT   NULL   default    '   ',                                          ' UserID '    varchar (+)    NOT   NULL    default    '   ',                                            engine=innodb   default   charset=utf8;  

   There must be utf-8 behind.

5. 3

   3. When setting the URL: (This is the most critical step)

   Many people do not have this set up will be wrong.

   Jdbc:mysql://localhost:3306/database?useunicode=true&characterencoding=utf-8

Java write MySQL Chinese garbled problem (fix)