Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

CLIENT_CHARSET

Umut TekinJan 23 2021 — edited Jan 23 2021

Hi there,
I am using 19c client and my database's NLS parameters like these:
Capture.PNGAlso my clients specs are:

Capture1.PNGWhile (Windows 10 x64) I am using sqplus, I get this(you can see my NLS_LANG environment variable on the top of command line):
image.pngMy 19c client home regedit NLS_LANG variable also is set to AMERICAN_AMERICA.W8ISO8859P9.
Yet, when I using TOAD for Oracle:
image.pngand using SQL Developer:
image.pngI got confused. On the internet they say NLS_LANG environment variable should be enough for setting client character set, but clearly it isn' t.
How can I overcome this situation?

Thanks in advance!

Comments
Post Details
Added on Jan 23 2021
0 comments
222 views