Excel into Oracle - corrupting characters

More
10 years 6 months ago #6749 by rudolfsun
Hi were importing Chinese and Japanse characters into the database from Excel.


Weve noticed its changing the values from their original utf-8 character to a question mark. The database is setup correctly as we can insert through access and use the ETL tool for csv and txt. However when it comes to xlsx it seems to not recognise the encoding. We are using Oracle 11.

Is there a setting we have missd?

thanks

attached is the file and the corruptions
Attachments:

Please Log in or Create an account to join the conversation.

More
10 years 6 months ago #6750 by rudolfsun
I think I found it, I switched to use conventional path loading and it fixed it

thanks

Please Log in or Create an account to join the conversation.