Configuration - Unicode enabled

[fcwojtul]

Hi!

We have data in the database in various languages, also in Russian. In configuration, I selected "Unicode enabled". However, the query does not return data.
Select *
From table_name t
Where instr (t.column_name, '')> 0;

If the condition would look like this: where instr (t.column_name, N'')> 0;
Data is found.
What is the Unicode enabled option for?

 

[Marco Kalter]

If this option is disabled, all Unicode data be converted to the client character set. When it is enabled, Unicode data will be fetched as Unicode without conversion.

However, if you want to use Unicode text in your SQL or PL/SQL code, you will need to set the client character set to UTF8. To do so, modify the NLS_LANG setting of the client to _.UTF8. For example:

NLS_LANG=AMERICAN_AMERICA.UTF8

You can also make this setting specifically for PL/SQL Developer by adding the above line to the Params.ini file in the PL/SQL Developer installation directory.