Wednesday, October 24, 2012

How to set Oracle SQL*PLUS character set

PROBLEM:
When opening your SQL*PLUS you see unrecognized characters, something like this:

SOLUTION:
To change SQL*PLUS language to english:
1. Close SQL*PLUS
2. Search "NLS_LANG" in the registry
3. Change the value to AMERICAN_AMERICA.WE8MSWIN1252
4. Open again SQL*PLUS to see changes

If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!

1 comment:

  1. Hi, nice demonstration how to set Oracle SQL*PLUS character set.Thanks...

    -Aparna
    Theosoft

    ReplyDelete