Retrieving and Inserting Chinese chars using JDBC [Archive]

View Full Version : Retrieving and Inserting Chinese chars using JDBC

cusp

02-14-03, 16:43

Hi all,

When I retireve chinese data from Access database using jdbc and print
it into a file,I am not seeing the Chinese characters visible in
Access but instead I see a '?'inplace of each chinese
character.Similarly when I try to insert chinese data into Access, I
am seeing '?' characters in the database instead of chinese
characters.I am sure it is not a problem with reading/writing
files,since I tested that issue and it is working fine.Is it a problem
with jdbc or the database drivers ? How do I go about solving this
problem???

Cheers!

GadgetGuru

02-21-03, 08:37

your JDBC driver don't have the specific codepage installed or can't handle it.

I suggest to take a look at DDTEK's JDBC driver (http://www.datadirect-technologies.com)

Emmon

02-24-03, 14:39

Hi

I'm not sure if this issue is to do with the Unicode support in the JDBC layer but you might find that the problem is with Access itself. I believe the only current version of Access that works is the Access XP version, or at a pinch the preceeding version. If there is a problem with the JDBC driver, you can download a copy of some Unicode enabled drivers from www.openlinksw.com

HTH
Emmon