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).