Arabic display over 10g linked server

• Nawar.Tabaa

  Ten Centuries

  Points: 1352

  More actions

  April 14, 2010 at 2:29 am

  #213798

  - I created a linked server "Microsoft OLE DB Provider for Oracle" to pull data from Oracle 10g.

  - When pulling the data Arabic characters are displayed as 'äæÇÑ ØÈÇÚ'.

  - On the same MS SQL server, I have another linked server that pulls from 8i and Arabic displayed fine.

  - When I submit the same query using the 10g SQL Plus, Arabic displayed well.

  On the server, I have 8i client installed, I installed 10g and the problem remains, I tried to uninstall the 8i but the problem remains, however, the installer seems didn't remove the 8i client.

  Any help?

• Nawar.Tabaa

  Ten Centuries

  Points: 1352

  More actions

  April 14, 2010 at 11:47 pm

  #1151883

  Well, the problem solved by conversion to the national character set,

  SELECT UNISTR(My_Column), this to return NVARCHAR(2) data type which to be understood by the SQL Server.