How to solve Chinese garbled characters written into MySQL using Java

When the page value contains Chinese characters, you can use the filter to compile it. However, it is easy to use system. Out. println to output Chinese characters and insert it into mysql. It is garbled. (Chao, your free space may also be the problem)

What should we do? Do the following:

1. When creating a database:

Create Database 'Db'
Character Set ' Utf8 '  
Collate ' Utf8_general_ci ' ;

2. When creating a table:

Create Table 'Tablea '(
'Id' Varchar ( 40 ) Not Null Default '   ' ,
'Userid' Varchar ( 40 ) Not Null Default '   ' ,)
Engine = InnoDB Default Charset = Utf8;

 

3. When setting the URL:

JDBC: mysql: // Localhost: 3306/database? Useunicode = true & amp; characterencoding = UTF-8