Re: determining client charset of a session

From: Jurij Modic <jmodic_at_src.si>
Date: Thu, 29 Apr 1999 20:56:20 GMT
Message-ID: <3728c762.15778478@news.arnes.si>

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 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 - 15:56:20 CDT