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.

valex · Accepted Answer

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:

Donate For Us