Solved

Character Set (NLS_LANG) query

Posted on 2003-12-09
2
1,375 Views
Last Modified: 2008-03-04
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
0
Comment
Question by:chekban
2 Comments
 
LVL 24

Accepted Solution

by:
shivsa earned 50 total points
ID: 9909439
yes.
NLS_LANG is environment variable and read by shell to execute things which needed this variable, it is just like programming, if u set a vraible something and then in next line set to something else, it will have the last value.
I hope i understand your question correctly.
0
 
LVL 8

Expert Comment

by:baonguyen1
ID: 9909589
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
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question