Tuesday, August 14, 2007

MS Access Unicode & Java JDBC


It's been a nightmare migrating data from MS Access full of unicode data to java database Derby.
Since the JDBC-ODBC bridge driver doesn't support UTF-16, you'll end up with ???????? when it should be កខគឃង.

Fortunately, there are alternative drivers. I've tried HXTT Access which support unicode.
The trial version limits 1000 transactions; enough for my 3225 records with 4 times execution.

After importing the data to Derby.
I'm ready to go to next step. :)