Execute Mysql query contains chinese character using java program

Question

When I execute SQL query contains chines character, the query is executed successfully. When I open the mysql query browser I could see only ???? instead of Chinese texts. If the same query executed from the mysql query browser it works fine.

Jigar Joshi · Accepted Answer · 2011-01-24 12:44:41Z

4

Try connecting with following switch

 String url = "jdbc:mysql://host/database?characterSetResults=UTF-8&characterEncoding=UTF-8&useUnicode=yes";

answered Jan 24, 2011 at 12:44

Jigar Joshi

241k42 gold badges409 silver badges446 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

maaartinus · Accepted Answer · 2011-01-24 14:35:25Z

0

All encoding must be the same (there are exceptions but let's forget them): the encoding used by the DB, the connection encoding use by the Java process and the one used by the query browser. You need to change the one used by Java, since the other two seem to be OK.

answered Jan 24, 2011 at 14:35

maaartinus

46.8k40 gold badges176 silver badges343 bronze badges

1 Comment

Selvanayagam Over a year ago

I have solved the problem thank you for the reply. i have used the code given by joshi it worked fine.

Collectives™ on Stack Overflow

Execute Mysql query contains chinese character using java program

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related