Unicode : cannot query filter with NVARCHAR2 column

[orca777]

Hi,
this is not a POL/SQL-Developer specific problem - but help would be appreciated.

Configuration Server :

NLS_CHARACTERSET WE8ISO8859P15
NLS_NCHAR_CHARACTERSET AL16UTF16

Client :

NLS_LANG GERMAN_GERMANY.WE8MSWIN1252

Column definition :

LEGALNAME NVARCHAR2 (255);

If i store for example a kyrillic name with the application i am able to finde the row searching the for the most current modification date and with correct kyrillic coded name.

but if i want to query by the Legalname - a)/b) does not work;

A) SELECT * FROM COMPANY WHERE LEGALNAME = 'Kyrillic String';
B) SELECT * FROM COMPANY WHERE LEGALNAME = N'Kyrillic String';

Do you have some hints???

kind regards
Karl

 

[Marco Kalter]

Does it help if you change the client character set to NLS_LANG GERMAN_GERMANY.UTF8?

 

[orca777]

Hi, found a configuration with PL/SQL-Developer which worked!

in windows registry in Oracle 10 Home following keys I set :

NLS_LANG=GERMAN_GERMANY.UTF8
ORA_NCHAR_LITERAL_REPLACE=TRUE

changing the character set to UTF8 could run into conversion conflicts running against a database using WE8ISO8859P1 as database character set;

cheers
Karl