Tuesday, August 14, 2007
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. :)