Japanese Data Not Displayed Correctly Using Excel And Oracle Odbc Driver (Doc ID 563244.1)

Last updated on JULY 05, 2017

Applies to:

Oracle ODBC Driver - Version: 9.2.0.1 to 10.2.0.3.17 - Release: 9.2 to
Microsoft Windows (32-bit)
Microsoft Excel 2003 SP3

Symptoms

Oracle Client version 9.2.0.1.0

Oracle ODBC Driver version 9.2.0.1.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

  1. Connected to the Oracle Database using AL16UTF16 characterset.
  2. 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'));
    commit;
    Note: Please note that the hex values were verified as being correct before trying to repo the problem.
  3. Import the data into Microsoft Excel 2003 with sp3 and it was displayed as upside down
    question marks.

Cause

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