1 Reply Latest reply: Mar 9, 2012 5:02 AM by 922827 RSS

    Problem with Arabic characters

    917430
      Hi:

      I don't know if this is the correct place to post the question, but here it goes...
      I have an SQL 2005 database, connected via a Linked Server to an Oracle Database.
      I have a table in SQL that contains arabic characters, and I need to insert it into an Oracle table.
      These characters appear as "????" after being inserted in the oracle table.
      I guess I hace some collation/characterset problem, but cannot finf the solution.

      The column where the arabic characyers are saved in SQL is defined as:
           [Remarks] [nvarchar](1000) NULL,
      And default SQL server collation is: SQL_Latin1_General_CP1_CI_AS
      When I do a select on this table, it can see arabic correctly.


      ORACLE NLS CONFIGURATION IS:

      PARAMETER VALUE
      ------------------------------ ----------------------------------------
      NLS_LANGUAGE AMERICAN
      NLS_TERRITORY AMERICA
      NLS_CURRENCY $
      NLS_ISO_CURRENCY AMERICA
      NLS_NUMERIC_CHARACTERS .,
      NLS_CHARACTERSET AR8MSWIN1256
      NLS_CALENDAR GREGORIAN
      NLS_DATE_FORMAT DD-MON-RR
      NLS_DATE_LANGUAGE AMERICAN
      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
      NLS_NCHAR_CHARACTERSET AL16UTF16
      NLS_RDBMS_VERSION 11.1.0.6.0


      The sql sentence in SQL server that moves the data to oracle is:
      INSERT INTO openquery(Oracle_DB, 'select Ticket_NO,Remarks from webportal.webcc_escal_det')
           (Ticket_NO,Remarks )
           SELECT Ticket_NO, Remarks
           FROM Details(nolock)


      Thanks in advance!!

      Mariana