Solution to garbled database data in java

Java database garbled solution:

1. When creating the database:

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

2. When creating the 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&characterEncoding=UTF-8

For more java knowledge, please pay attention to java basic tutorial.

The above is the detailed content of Solution to garbled database data in java. For more information, please follow other related articles on the PHP Chinese website!