Solved

Character Set (NLS_LANG) query

Posted on 2003-12-09
2
1,371 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Processing of multiple cursor 6 47
Oracle - SQL Parse String 5 34
Trying to get a Linked Server to Oracle DB working 21 60
Oracle function to insert records? 15 42
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

772 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