extracting unicode text from mysql to java

Question

I have a table 'test' in my database with a column 'msg' that stores strings in various languages like English, Hindi, Telugu, etc. These strings are displayed properly in the database. But if i extract it into my java code and print it on the console using system.out.println , it shows ????????? instead of the actual string.

Is this because the font used in eclipse console does not support these scripts? If so, how can i change the font to something else?

score 3 · Accepted Answer · answered Jun 17 '13 at 10:46

3

You cannot print the UTF-8 characters on console with its default settings. Make sure the console you use to display the output is also encoded in UTF-8.

In Eclipse for example, you need to go to Run Configuration > Common -> Encoding -> Select UTF-8 from dropdown.

enter image description here

answered Jun 17 '13 at 10:46

Juned Ahsan

67,789
12
98
136

yeah.. it seems i can accept it as an answer only after 5 more minutes – newbee Jun 17 '13 at 10:53

score 1 · Answer 2 · answered Jun 17 '13 at 10:48

Try adding characterEncoding=UTF-8 parameter to the end of your JDBC connection URL. Even set the table and column character set to UTF-8. This article explains how to do that.

Also change the Eclipse console Output encoding using

Run Configuration > Common -> Encoding

extracting unicode text from mysql to java

2 Answers2

Linked