Meaningless Drivel is fun!*
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
Author

UTF-8 and MS Access

Sahil Sharma
Ranch Hand

Joined: Aug 27, 2003
Posts: 152
Hi

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?

Thanks.
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
Sheriff

Joined: Oct 27, 2005
Posts: 19682
    
  20

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.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
 
jQuery in Action, 2nd edition
 
subject: UTF-8 and MS Access