Solved

Character Set (NLS_LANG) query

Posted on 2003-12-09
2
1,384 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Suggested Solutions

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
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.

734 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