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
