Questions about SQL statement condition values not found in Chinese

When using the JDBC link MySQL to execute SQL statements, the WHERE condition in the SQL statement, the parameter value with Chinese, the query is not the result, and where condition, the parameter value is a number or letter can be queried normally,

The reason is MySQL character_set_connection default setting is not UTF8, my workaround, open command line prompt operation interface login MySQL

Execute set character_set_connection = UTF8; command, and then set character settings in the URL of the database connection such as Jdbc:mysql://localhost:3306/goods?useunicode=true &characterencoding=utf-8, this will solve the problem.

Online Some methods have, modify INI file, tried invalid, about the problem can refer to the article http://www.cnblogs.com/discuss/articles/1862248.html

From the original: csdn-blog: @ Struggle of the two forced youth

Questions about SQL statement condition values not found in Chinese