Hi Experts-
May I know are there any disadvantages in setting up the NLS_LANG to AMERICAN_AMERICA.AL32UTF8.
I read few things to understand, I think it should be fine, but couldn't come to a conclusion.
Below is our database configuration.
LANGUAGE AMERICAN
TERRITORY AMERICA
CHARACTER SET AL32UTF8
We do store both English and French data, on Unix side the NLS_LANG is not set, so whenever I run few shell scripts or run some sql files on unix which will fetch the french data the data was missing(the special characters) as I understood by default the NLS_LANG will be set to US7ASCII.
So every time I need to export NLS_LANG to set to AMERICAN_AMERICA.AL32UTF8 on the session and run those few scripts/files. We have many other processes which will not pick the french data.
Would like to understand what happens if I set NLS_LANG to AMERICAN_AMERICA.AL32UTF8 permanently, will I loose some data or will some data gets manipulated.
Could you please help me in understanding.
Thank you,
Pradeep