Re:RE: How to set client's characterset on session level?

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" <alexandre.gorbatchev_at_avermann.de>
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: dgoulet_at_vicr.com [mailto:dgoulet_at_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" <alexandre.gorbatchev_at_avermann.de>
> 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: alexandre.gorbatchev_at_avermann.de
>
> 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: ListGuru_at_fatcity.com (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: dgoulet_at_vicr.com

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: ListGuru_at_fatcity.com (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).