Re: NLS question

From: Yechiel Adar <adar666_at_inter.net.il>
Date: Tue, 22 Mar 2011 11:52:55 +0200
Message-id: <4D887177.2000406_at_inter.net.il>

Sorry, but I do not know of any documents in this area.

I led a project to convert all our databases to a different nls_charset so I learned a little of this.

Yechiel Adar
Israel

On 17/03/2011 02:28, De DBA wrote:
> Thanks for that explanation. Clearly there is more to it than meets
> the eye. Perhaps the story changes again if the inserting clients
> essentially run on the same server as the database (e.g. via a
> telnet/ssh client or remote X session) and use bequeath connections
> rather than SQLNet?
>
> I'd be quite interested to learn more on how character data is handled
> by the different components of the Oracle stack. Do you know of any
> publicly available documentation on the topic?
>
> Cheers
> Tony
>
> Yechiel Adar wrote:
>> That is exactly the point where you are mistaken.
>> Sql net does a translation of the data from the client nls_charset to
>> the database nls_charset replacing any illegal, for the database
>> nls_charset, characters in the data with 191 , or (I think) 61.
>> ...
>>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 22 2011 - 04:52:55 CDT