Toad World® Forums

[No Subject]


#1

Out of curiosity, I have run Toad Advisor. I get 1 Warning: Incorrect NLS_LANG.
Everything seems OK, so I don’t know why this error occur. My Oracle
registry entry is:

Any thoughts about what is wrong?

TIA,

Dave

David Reed

Principal Engineer

Major Projects and Operations

I&C Design Integration Engineering

Westinghouse Electric Company

600 Cranberry Woods

Cranberry Township PA 16066, USA

Phone: +1 (412) 374-6739

Fax: +1 (412) 374-4575

Email: reedda@westinghouse.com

Home Page: www.westinghousenuclear.com

image001.png


#2

The Advisor looks at your client character set and your active Home’s
NLS_LANG and sees if they match according to what Oracle recommends. For the
various Oracle Utilities to work, NLS_LANG’s value needs to correspond
precisely to the client character set.

For the typical English character set that would be
AMERICAN_AMERICA.WE8MSWIN1252. That is the safer bet. Setting NLS_LANG to a UTF8
value doesn’t let the database know what your client character set is.
This won’t matter for Toad 10+ itself, but for non-Toad, non-Unicode
applications can result in data errors.
image001.jpeg


#3

The Advisor looks at your client character set and your active Home’s
NLS_LANG and sees if they match according to what Oracle recommends. For the
various Oracle Utilities to work, NLS_LANG’s value needs to correspond
precisely to the client character set.

For the typical English character set that would be
AMERICAN_AMERICA.WE8MSWIN1252. That is the safer bet. Setting NLS_LANG to a UTF8
value doesn’t let the database know what your client character set is.
This won’t matter for Toad 10+ itself, but for non-Toad, non-Unicode
applications can result in data errors.