Alex,
Humm, it would appear that you are right. After looking through the manuals
and MetaLink it appears that the only why you can change the charecterset is at
the client by updating the nls_lang environment (or registry if windoes)
setting. Seems that characterset is specifically for how the client displays
things. Damn nasty.
Dick Goulet
____________________Reply Separator____________________
Author: "Alexandre Gorbatchev" <[EMAIL PROTECTED]>
Date: 11/15/2002 4:44 PM
Dick,
I have already thoroughly RTFMed on this issue, but didn't find anything
suitable using ALTER SESSION SET NLS_*
Please, correct me if I'm wrong.
NLS_LAN consists of 3 parts: language, territory and characterset. Language
and territory can be set/changed at session level as parameters NLS_LANGUAGE
and NLS_TERRITORY respectively. But there is no alternative (at least I
didn't find one) for characterset.
I can ALTER SESSION SET NLS_LANGUAGE=AMERICAN. However, this does not change
character encoding scheme.
Thanks,
Alex
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:dgoulet@;vicr.com]
> Sent: Friday, November 15, 2002 4:06 PM
> To: Alexandre Gorbatchev; Multiple recipients of list ORACLE-L
> Subject: Re:How to set client's characterset on session level?
>
>
> See "alter session set nls_language" in the SQL Reference manual.
>
> ____________________Reply Separator____________________
> Subject: How to set client's characterset on session level?
> Author: "Alexandre Gorbatchev" <[EMAIL PROTECTED]>
> Date: 11/15/2002 2:58 AM
>
> Hello guys,
>
> I need to use two (or more) different client applications from the same
> client workstation. Applications use different charactersets WE8PC858 and
> WE8ISO8859P1. That's a sort of having different NLS_LANG for each session.
>
> Maybe I can create a specific connect description in listener? Or
> I can put
> something in AFTER LOGIN trigger? Or put some parameters when establishing
> connection?
>
> I can change NLS_TERRITORY but not characterset. I am a little
> bit confused
> because cannot resolve this rather simple (I thought) case.
>
> Any advice?
> TIA,
> Alex
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Alexandre Gorbatchev
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
