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:
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.
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.
