unicode support java and mysql

Question

I have a string of unicode characters like this:\u4f60\u597d in Java But when I print it to the console the it shows "??". Also when I update a Mysql table with this data it saves the same "??" string. I have set the Mysql charset to utf8 but it is not working

And the question is? Show some code, the way the database is defined, etc. Also, \u4f60\u597d is the UTF-16 representation of a Unicode code point — fge
– fge, Commented Mar 14, 2014 at 11:44
@fge The question is too obvious, If you dont get it you'll never get it.Nevertheless, the question is how can I add support for unicode characters in java and mysql. — Jain
– Jain, Commented Mar 14, 2014 at 11:51
The console probably uses Windows-1252 or so and cannot represent the text; for MySQL also the connection string, url, must specify UTF-8 transport too: stackoverflow.com/questions/138948/… — Joop Eggen
– Joop Eggen, Commented Mar 14, 2014 at 11:52
I am afraid there is no question there. All you say is "it doesn't work", you don't provide any material other than that (how you have set up your database, how you write to the database, etc). — fge
– fge, Commented Mar 14, 2014 at 11:55

Hirak · Accepted Answer · 2014-03-14 12:03:17Z

1

If you are checking the output in some IDE, you need to set the character encoding there. Same for the MySql client editor that you are using. If you are using eclipse IDE, you can change it from Windows>Preferences>General>Workspace

answered Mar 14, 2014 at 12:03

Hirak

3,6491 gold badge24 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

unicode support java and mysql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related