This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line!
See this thread for details.
The moose likes Java in General and the fly likes UTF-8 and MS Access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "UTF-8 and MS Access" Watch "UTF-8 and MS Access" New topic

UTF-8 and MS Access

Sahil Sharma
Ranch Hand

Joined: Aug 27, 2003
Posts: 152

I am retrieving the data from MS Access database using stand alone java client. One of the columns in the table contains UTF-8 character (Japanese). When I fetch the data and print on the console it is not showing me the actual value, instead I am getting junk data with ???. I have also set the character encoding to UTF-8 as part of my connection string but still it is not working. What could be the possible reason for this?

Lanny Gilbert
Ranch Hand

Joined: Jun 11, 2002
Posts: 103
Please show your code.
Sahil Sharma
Ranch Hand

Joined: Aug 27, 2003
Posts: 152

When I sysout the value. It is coming as ???. I am using eclipse as an IDE and have the character encoding there as well to UTF-8 and still it is not working.
Rob Spoor

Joined: Oct 27, 2005
Posts: 19538

The console, to which System.out prints (and System.err as well), cannot handle Unicode characters, or almost anything that isn't ASCII. It's not a Java limitation.

How To Ask Questions How To Answer Questions
I agree. Here's the link:
subject: UTF-8 and MS Access
Similar Threads
Convert special characters to readable ones
Post request doesnot support spanish characters in case of Weblogic + Solaris combination
String functions and ISO-8895-1 encoding.
How many bits are there for UTF characters?
Different behavior between getWriter and getOutputStream