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" <[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).
RE: How to set client's characterset on session level?
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: 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).
RE: How to set client's characterset on session level?
Hi, > I think you can manually trigger "alter session set > nls_language ..." via some button in your application, or via > logon trigger(if 8i+). No that will not set client's characterset. > Or run os command export NLS_LANG= nls_lang1 etc > and run your app:), export NLS_LANG=nls_lang2 and run your second > app, this should do the trick. That's how I'm doing this now, but I have to mess up with environment variables on Win :( that's not *nix. Users may run not the .bat file, but .exe instead and I don't want (or I can't) change the app itself. I'm looking for other possible solutions. Thanks, 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).
Re: How to set client's characterset on session level?
Alexandre Gorbatchev, I think you can manually trigger "alter session set nls_language ..." via some button in your application, or via logon trigger(if 8i+). Or run os command export NLS_LANG= nls_lang1 etc and run your app:), export NLS_LANG=nls_lang2 and run your second app, this should do the trick. Good luck. Regards zhu chao Eachnet DBA 86-21-32174588-667 [EMAIL PROTECTED] www.happyit.net www.cnoug.org(Chinese Oracle User Group) === 2002-11-15 02:58:00 ,you wrote£º=== >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: chao_ping 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).
How to set client's characterset on session level?
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).