Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I get the following error

when I login in by PL/SQL - please advice how to fix this?

Data character set (UTF8) and client character set (IW8MSWIN1255) are different character set conversion may cause unexpected results

you can set the client character set through the NLS_LANG env variable or NLS_LANG registry key in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE|KEY_OraClient10_home1

share|improve this question
up vote 2 down vote accepted

What do you mean "log in by PL/SQL"? Do you mean SQL*Plus? PL/SQL is a language used to write functions and procedures - you have to be logged in already before you can call them.

The message is fairly self-explanatory: if the client and database are using different character sets, results need to be converted from one to the other before being displayed at the client, which may cause "unexpected results" (like strange characters for example).

As the database is using UTF8 it makes sense to set the client side to use the same - how to do this depends on what platform your client is on.

On Windows, you can either set an environment variable or the NLS_LANG registry setting

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.