4 Replies Latest reply: Mar 11, 2013 12:06 AM by Allen Sandiego RSS

    Problem fetching Chinese Characters over DB Link

    Allen Sandiego
      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
          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
            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
              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
                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