Solution to garbled Chinese SQL statements in Java

Garbled characters refer to a series of characters in which some or all characters cannot be read because the local computer uses an inconsistent character set when opening the source file with a text editor.

We can solve the problem of garbled characters by modifying the encoding format. Let's take a look at how to solve the problem of garbled characters when inserting sql statements in Java.

Write the sql statement in java as follows:

#After output, it was found that the Chinese was not recognized and the Chinese was garbled

We can change DriverManage and add setting encoding at the end.

DriverManager.getConnection("jdbc:mysql://localhost:3306/数据库?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 Chinese SQL statements in Java. For more information, please follow other related articles on the PHP Chinese website!