I translate an application from french (NLS_LANG1 : french_france.WE8ISO8859P1) to arab (NLS_LANG2 : arabic_tunisia.AR8MSWIN1256). I have to change dynamically the NLS_LANG to run my application into arab or french.
Printable View
I translate an application from french (NLS_LANG1 : french_france.WE8ISO8859P1) to arab (NLS_LANG2 : arabic_tunisia.AR8MSWIN1256). I have to change dynamically the NLS_LANG to run my application into arab or french.
The database can only have one character set. If you are running on one database, you should use the UTF-8 character set.
Good luck.
ALTER SESSION can be used to dynamically change the NLS_LANG parameter value.
Is it possible to use the ALTER SESSION command when the character sets are absolutely different?
Thanks in advance.