Re: NLS question

  • From: Yechiel Adar <adar666@xxxxxxxxxxxx>
  • To: De DBA <dedba@xxxxxxxxxx>
  • Date: Tue, 22 Mar 2011 11:52:55 +0200

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.
...


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


Other related posts: