Re: NLS_LANG
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Thu, 28 May 2009 20:18:16 +0200
Message-ID: <4a1ed567$0$2854$ba620e4c_at_news.skynet.be>
>
> As far as i know, it can't be done from within the Oracle server.
> I guess, it should be done by os means, another difficulty may be in the
> term environment *variable*, i.e., it can be changed every time by the
> client.
>
> Best regards
>
> Maxim
>
Date: Thu, 28 May 2009 20:18:16 +0200
Message-ID: <4a1ed567$0$2854$ba620e4c_at_news.skynet.be>
Maxim Demenko schreef:
> Gerard H. Pille schrieb:
>> Maxim Demenko schreef:
>>> Gerard H. Pille schrieb:
>>>> Is there any way to determine the NLS_LANG of a client using SQL or
>>>> PL/SQL.
>>>>
>>>> sys_context('USERENV','LANGUAGE') gives the database characterset,
>>>> not the clients.
>>>>
>>>> Thanks,
>>>>
>>>> Gerard
>>>
>>> For local connections ( also using bequeth protocol) you can get the
>>> environment variables with dbms_system.get_env procedure.
>>>
>>> Best regards
>>>
>>> Maxim
>>>
>>
>>
>> Alas, we want to check if all PC's have been correctly configured,
>> even all clients.
>
> As far as i know, it can't be done from within the Oracle server.
> I guess, it should be done by os means, another difficulty may be in the
> term environment *variable*, i.e., it can be changed every time by the
> client.
>
> Best regards
>
> Maxim
>
Indeed, and we would like to prevent that. A client pretending to use the same character set as the database, can store quite some rubbish. Received on Thu May 28 2009 - 20:18:16 CEST