File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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: 20276

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
jQuery in Action, 3rd edition