Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: determining client charset of a session

Re: determining client charset of a session

From: Tim Besser <besser_at_openmarket.com>
Date: Thu, 29 Apr 1999 23:22:09 -0400
Message-ID: <372921E1.A145873A@openmarket.com>

Jurij Modic wrote:
>
> On Thu, 29 Apr 1999 16:46:29 GMT, cocoa1826_at_my-dejanews.com wrote:
>
> >Is there anyway to determine the charset of a client from within a session?
> >The server's charset can be determined with a query like: select value from
> >v$nls_parameters where parameter = 'NLS_CHARACTERSET' I want to compare to
> >the client's.
>
> Use the function USERENV('LANGUAGE') - it will return the NLS_LANG
> setting of the current session in the standard form
> LANGUAGE_TERRITORY.CHARCATERSET.
>
> Example:
>
> SCOTT_at_PO73> select userenv('LANGUAGE') from dual;
>
> USERENV('LANGUAGE')
> ----------------------------------------------------
> SLOVENIAN_SLOVENIA.EE8MSWIN1250
>

Although what I've seen on both V7.3 and 8, this will return with the language and territory setting from NLS_LANG, but not the charset. No matter what the charset of NLS_LANG, the above SQL always returns a value with the server charset.

--tim

> Regards,
> Jurij Modic <jmodic_at_src.si>
> Certified Oracle7 DBA (OCP)
> ================================================
> The above opinions are mine and do not represent
> any official standpoints of my employer
Received on Thu Apr 29 1999 - 22:22:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US