Post reply

Arabic display over 10g linked server

  • 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?

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply