Re: alter session set nls_characterset = ?????

From: Pavel Polcar <pavel.polcar_at_berit.cz>
Date: 22 Apr 1998 10:18:32 GMT
Message-ID: <01bd6dd7$fb07cab0$47c3657e@polcar_nt4006>

Hi,
to my knoledge, you cannot change the character set once you are logged. To change it before logging in, set the environment variable NLS_LANG, e.g. as follows
NLS_LANG=AMERICAN_AMERICA.EE8MSWIN1250
Inside the session, you can override the language (alter session set nls_language=GERMAN), or the territory (alter session set nls_territory=GERMANY). Under WINDOWS NT, you can define NLS_LANG in the registry.

Hth,
--
Pavel Polcar

Saad Ahmad <saad.ahmad_at_mchugh.com> wrote in article <01bd6c9e$ee74b360$2207030a_at_sahmad-pc.mfa.com>...
> Hello !!!!
>
> Well this statement is not supported, but can I get this kind of
behaviour
> some how.
>
> Once I have logged into Oracle, I want to change the characterset used
for
> the client process.
>
> Thanks
> --
> ====
> Saad Ahmad
> McHugh Software International
> saad.ahmad_at_mchugh.com
>
Received on Wed Apr 22 1998 - 05:18:32 CDT