Japanese Data Not Displayed Correctly Using Excel And Oracle Odbc Driver
Last updated on JULY 05, 2017
Applies to:Oracle ODBC Driver - Version: 18.104.22.168 to 10.2.0.3.17 - Release: 9.2 to
Microsoft Windows (32-bit)
Microsoft Excel 2003 SP3
Oracle Client version 22.214.171.124.0
Oracle ODBC Driver version 126.96.36.199.0
Japanese characters that are retrieved from an Nvarchar datatype are displayed as upside down question marks in Microsoft Excel using the Oracle ODBC driver on an English (US) Windows Machine with NLS_LANG set to AMERICAN_AMERICA.UTF8. They are able to view the data correctly in Sql Developer.
Steps to reproduce the problem
- Connected to the Oracle Database using AL16UTF16 characterset.
- Created the test table using the following sql:
create table jap (first_name nvarchar2(50),last_name nvarchar2(50));
insert into jap values (Unistr('\5065\53f2'),Unistr('\6e21\8fba'));
Note: Please note that the hex values were verified as being correct before trying to repo the problem.
- Import the data into Microsoft Excel 2003 with sp3 and it was displayed as upside down
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms