<div>
No, when you set the env variable from the command prompt, the last one will override the previous setting. In you case NLS_LANG is UTF8
</div>


No, when you set the env variable from the command prompt, the last one will override the previous setting. In you case NLS_LANG is UTF8

<div>
<div class="content wysiwyg-content">
Hi ,<br />
<br />
I'd like to ask wether we can set more than one character set as an environment variable in a command prompt.<br />
i.e<br />
<br />
SET NLS_LANG=AMERICAN_AMERICA.<wbr />ZHT16BIG5<br />
SET NLS_LANG=AMERICAN_AMERICA.<wbr />UTF8<br />
<br />
Is it only one character set &nbsp;is in use ? in this case the last one which is the UTF8 .<br />
Thanks
</div>
</div>


Hi ,

I'd like to ask wether we can set more than one character set as an environment variable in a command prompt.
i.e

SET NLS_LANG=AMERICAN_AMERICA.ZHT16BIG5
SET NLS_LANG=AMERICAN_AMERICA.UTF8

Is it only one character set  is in use ? in this case the last one which is the UTF8 .
Thanks

Character Set (NLS_LANG) query

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.