This discussion is archived
0 Replies Latest reply: Oct 19, 2012 1:25 AM by 969464 RSS

Query behaviour: WE8MSWIN1252 vs AL32UTF8

969464 Newbie
Currently Being Moderated
Hello,

I've got MSSQL 2008 64bit linked to Oracle databases using OraOLEDB.Oracle 11.2.0.3.0.

The query in question is something like "select * from server..schema.table where column='123'". col is of type varchar2.

- When run against Oracle 9i with NLS_CHARACTERSET='WE8MSWIN1252', the predicate is executed in the linked Oracle DB.

- When run against Oracle 11g with NLS_CHARACTERSET='AL32UTF8', all rows are fetched from the linked Oracle DB and the predicate is executed in MSSQL.

Has anyone managed to push predicate evaluation against varchar2 columns to the remote server with UTF-8, using four-part names?

The linked server setup is identical in both cases. The table in question has been migrated from 9i to 11g; indices are the same. NLS_LANG on the MSSQL machine is set to GERMAN_GERMANY.WE8MSWIN1252. The MSSQL collation is set to Latin1_GENERAL_BIN2, as NLS_SORT='BINARY'.

Any hints appreciated,

Dirk.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points