Unanswered: Chinese data migration from oracle to ms access 2000
I am trying to migrate data from oracle database to ms access database using java . When i cannect to oracle and retrieve data for displaying on html it is perfect .where as while connecting to ms - access 2000 and retrieve data only junk characters are returned. Can any one suggest what might be the cause of the problem and best way to migrate data from oracle to access.
Originally posted by osy45
have you set access 2000 character set properly to utf8 or the like
my suggestion is, access is not installed using double byte charsets as chinese are ...
I tried using utf-8 encoding and now say 8 out 10 chinese characters are displayed properly . The data is read from ms access as string and converted using utf-8 and used for display.
can u let me know what i might be missing out in the process that i keep getting 1 or 2 characters as junk.