This week's book giveaway is in the JavaFX forum.
We're giving away four copies of Introducing JavaFX 8 Programming and have Herbert Schildt 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 Introducing JavaFX 8 Programming this week in the JavaFX 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: 104
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: 20128

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
It's not a secret anymore!