Skip to Main Content

Java Programming

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Program outputs Chinese characters as Question Marks

997761Mar 19 2013 — edited Mar 21 2013
I currently have a database in mysql that stores chinese characters among other things, the field of the particular column that stores the chinese characters are encoded using utf-8. Everything is sound when I insert new rows direct using mysql, when I view the values in the table, all characters are returned as they should be. However, when I insert values to the table using java.sql a lot of garble is return instead.

Here is an example of the output returned when the values were inputted using a java program:
http://s20.postimage.org/9a7xm1xrx/Screen_shot_2013_03_19_at_12_42_30.png

Here is some results returned that were inputted in mysql and what the output should have looked like:
http://s20.postimage.org/k74nx2v5p/Screen_shot_2013_03_19_at_12_47_03.png


Another problem I am having (possibly the same problem) is that using the values inputted using mysql, and using a java program to output the values in the terminal returns question marks in place of where the Chinese characters/special characters should be:
http://s20.postimage.org/6vg21mhj1/Screen_shot_2013_03_19_at_12_55_23.png


Does anyone have any ideas as to why this is?

Thanks in advanced!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 18 2013
Added on Mar 19 2013
6 comments
2,997 views