Program outputs Chinese characters as Question Marks
997761Mar 19 2013 — edited Mar 21 2013I 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!