| How to find the NLS_LANG encoding on client machine [message #32198] |
Mon, 09 August 2004 04:21  |
Charandeep Singh
Messages: 2
Registered: August 2004
|
Junior Member |
|
|
hi all
If i have to get the NLS_LANG encoding of the client machine
how should i get it in windows 2k case except the environment variable
if i have user name and passoword and have to get the database server as well as client NLS_LANG set how should i get it in PRO C is there ne way the actual encoding is at the client end and database end in PRO C in registry how do i determine what database encoding is for which database if i have oracle 8i and 9i both installed and have to get the encoding of a particular database with username and password given how should go about it
plzzzzzzzz help me
thanx in advance
bye
charandeep
|
|
|
|
| Re: How to find the NLS_LANG encoding on client machine [message #32199 is a reply to message #32198] |
Mon, 09 August 2004 05:22  |
Ultra
Messages: 98
Registered: November 2003
|
Member |
|
|
ALTER SESSION SET NLS_LANGuage= FRENCH;
SELECT * FROM nls_session_parameters where PARAMETER='NLS_LANGUAGE'
>> NLS_LANGUAGE FRENCH
ALTER SESSION SET NLS_LANGuage= AMERICAN;
SELECT * FROM nls_session_parameters where PARAMETER='NLS_LANGUAGE'
>> NLS_LANGUAGE AMERICAN
|
|
|
|
| Re: How to find the NLS_LANG encoding on client machine [message #32218 is a reply to message #32199] |
Mon, 09 August 2004 19:45 |
Charandeep Singh
Messages: 2
Registered: August 2004
|
Junior Member |
|
|
hi thanx for replying to my query
what i want to know is that if i have retrieve the code page of the client
the command u have given me will alter the database charset/code page
if the code page is diff at client end and at server end how will i come know about it
we set the envoironment variable in unix case in windows case it is also done thru regisrty
where is the charset/codepage of particular DB stored in ????
plzzz help
thanx
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
