Solved

Character Set (NLS_LANG) query

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

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Bulk insert into global temporary table 2 41
UNIX SCP 5 47
Pfile and SPfile - Oracle 2 35
oracle rollup query 3 38
Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
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 …
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

760 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now