Collation problem with Oracle as linked server

I have the following configuration of the servers:
1.Oracle 9i (database codepage is CL8MSWIN1251)
2. MS SQL Server 2000 Standard Edition (server codepage is
Cyrillic_General_CI_AS)
Oracle is the linked server in the SQL. When I use
query "Select * from openquery(ORASRV, 'select field1,
field2 from table1')" I receive question symbols ("?")
instead of russian letters.
What should I do to correct this situation?Sergey,
I don't know Oracle (sorry) but the COLLATE command is used by SQL Server to
move characters into a particular collation.
I see that Cyrillic_General is considered to be in code page 1251, which is
what Oracle is using, so I don't know why you would be getting back only
?.
Try:
'select field1 COLLATE Cyrillic_General_CI_AS,
field2 COLLATE Cyrillic_General_CI_AS from table1')
See if that resolves the problem.
Russell Fields
"Sergey Khanzhin" <skhan@.mail.ru> wrote in message
news:0d7d01c36177$e7ba61e0$a101280a@.phx.gbl...
> I have the following configuration of the servers:
> 1.Oracle 9i (database codepage is CL8MSWIN1251)
> 2. MS SQL Server 2000 Standard Edition (server codepage is
> Cyrillic_General_CI_AS)
>
> Oracle is the linked server in the SQL. When I use
> query "Select * from openquery(ORASRV, 'select field1,
> field2 from table1')" I receive question symbols ("?")
> instead of russian letters.
>
> What should I do to correct this situation?
>