PL/SQL Developer doesn't find records with russian letters

Question

In local machine I do this query:

    select * from allObjects where status = 'Изменено'

I get empty result. In server I do same query and get all records. DB and schema are same.

Answer 1

I guess this happens because of client session NLS_LANG is different from server language. Check your session NLS_LANG:

SELECT * FROM NLS_SESSION_PARAMETERS;

Try to set environment variable on your client computer from command line before connection:

set nls_lang=AMERICAN_CIS.CL8MSWIN1251

Here are some links to read about that:

• RUS: Oracle - Delphi - NLS_LANG
• RUS: Параметры NLS уровня сеанса
• Determine Oracle session client character set?
• Oracle: NLS_LANG FAQ