This discussion is archived
4 Replies Latest reply: Mar 10, 2013 10:06 PM by Allen Sandiego RSS

Problem fetching Chinese Characters over DB Link

Allen Sandiego Newbie
Currently Being Moderated
Hi,

I'm currently fetching data from SQL Server 2005 through a DB Link I created in my Oracle XE 11g. Some of these data are in Chinese Characters.

When doing a SELECT statement from the table using SQL Developer, it shows me ?????. When doing the same SELECT directly to the SQL Server using MS SQL Server Management Studio, it shows the correct character in Chinese.

Is there a setting so that I can properly fetch the data in my Oracle Database?

EDIT: Sorry forgot to provide NLS settings.
SQL> col parameter format a30
SQL> col value format a40
SQL> select * from nls_session_parameters;

PARAMETER                      VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE                   SIMPLIFIED CHINESE
NLS_TERRITORY                  CHINA
NLS_CURRENCY                   úñ
NLS_ISO_CURRENCY               CHINA
NLS_NUMERIC_CHARACTERS         .,
NLS_CALENDAR                   GREGORIAN
NLS_DATE_FORMAT                DD-MON-RR
NLS_DATE_LANGUAGE              SIMPLIFIED CHINESE
NLS_SORT                       BINARY
NLS_TIME_FORMAT                HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY              úñ
NLS_COMP                       BINARY
NLS_LENGTH_SEMANTICS           BYTE
NLS_NCHAR_CONV_EXCP            FALSE

17 rows selected.

SQL>
Thanks,
Allen
  • 1. Re: Problem fetching Chinese Characters over DB Link
    sb92075 Guru
    Currently Being Moderated
    Allen Sandiego wrote:
    Hi,

    I'm currently fetching data from SQL Server 2005 through a DB Link I created in my Oracle XE 11g. Some of these data are in Chinese Characters.

    When doing a SELECT statement from the table using SQL Developer, it shows me ?????. When doing the same SELECT directly to the SQL Server using MS SQL Server Management Studio, it shows the correct character in Chinese.
    It appears that you have a data display problem & I am not convinced that it has anything to do with XE;
    just SQL Developer.

    When was the last time SQL Developer properly displayed Chinese characters?
  • 2. Re: Problem fetching Chinese Characters over DB Link
    Allen Sandiego Newbie
    Currently Being Moderated
    sb92075 wrote:
    Allen Sandiego wrote:
    Hi,

    I'm currently fetching data from SQL Server 2005 through a DB Link I created in my Oracle XE 11g. Some of these data are in Chinese Characters.

    When doing a SELECT statement from the table using SQL Developer, it shows me ?????. When doing the same SELECT directly to the SQL Server using MS SQL Server Management Studio, it shows the correct character in Chinese.
    It appears that you have a data display problem & I am not convinced that it has anything to do with XE;
    just SQL Developer.

    When was the last time SQL Developer properly displayed Chinese characters?
    Hi,

    I've never had any chance to view Chinese characters before in SQL Developer. This is my first attempt.

    EDIT: I tried the following SELECT statement in SQL Developer and it seems to display the Chinese character just fine.
    select unistr('\8349') from dual;
    So I'm guessing the problem was while I was trying to fetch the data from the SQL Server DB.

    Regards,
    Allen
  • 3. Re: Problem fetching Chinese Characters over DB Link
    sb92075 Guru
    Currently Being Moderated
    Allen Sandiego wrote:
    sb92075 wrote:
    Allen Sandiego wrote:
    Hi,

    I'm currently fetching data from SQL Server 2005 through a DB Link I created in my Oracle XE 11g. Some of these data are in Chinese Characters.

    When doing a SELECT statement from the table using SQL Developer, it shows me ?????. When doing the same SELECT directly to the SQL Server using MS SQL Server Management Studio, it shows the correct character in Chinese.
    It appears that you have a data display problem & I am not convinced that it has anything to do with XE;
    just SQL Developer.

    When was the last time SQL Developer properly displayed Chinese characters?
    Hi,

    I've never had any chance to view Chinese characters before in SQL Developer. This is my first attempt.

    EDIT: I tried the following SELECT statement in SQL Developer and it seems to display the Chinese character just fine.
    select unistr('\8349') from dual;
    So I'm guessing the problem was while I was trying to fetch the data from the SQL Server DB.
    The data is good in the SQLServer DB & SQL Developer can display when it gets them.

    so problem is with the ODBC between the two systems.
  • 4. Re: Problem fetching Chinese Characters over DB Link
    Allen Sandiego Newbie
    Currently Being Moderated
    sb92075 wrote:
    The data is good in the SQLServer DB & SQL Developer can display when it gets them.

    so problem is with the ODBC between the two systems.
    Yes. I think so too.

    Is there a setting for this on the DB Link or the Gateway?

    Regards,
    Allen

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points