Re: NLS

I think the information is lost because the client does a conversion from us7ascii to we8iso8859p1; since the server is defined as 7-bit. On the server however, if NLS_LANG ist set to ....US7ASCII there is no conversion, the characters are passed without any modifications. Do you load the data from the client or from the server? (I think you load from the server, if you load it form the client, the 8th bit would be dropped...)
HTH
Michael

karmit_at_my-dejanews.com wrote:
>
> Hi,
>
> I have an Oracle7.3 server on Aviion, and client on Portuguese NT.
> The server is defined as AMERICAN_AMERICA.US7ASCII. The client is defined as
> PORTUGUESE_PORTUGAL.WE8ISO8859P1.
>
> Using select userenv('LANGUAGE') from dual on the client, I recived:
> PORTUGUESE_PORTUGAL.US7ASCII. Looking at the NT's registry, I found:
> NLS_LANG=PORTUGUESE_PORTUGAL.WE8ISO8859P1.
>
> 1. Why I have a difference between the registry and SQL*Plus?
>
> 2. When I fetch a Portuguese from the server (Which both the system and
> Oracle are defined as English), I see every thing OK. When I fetch it from
> the client (Which defined as Portuguese), I can not see the special
> Portuguese characters:
>
> select a, ascii(a)
> from char_tab
>
> a ascii(a)
> --- --------
> g 231
>
> select ascii('g') from dual
>
> ascii('G')
> ---------
> 103
>
> I can see that the client is dropping a bit, but I could not understand how
> the server shows 8 bit and the client does not. I could understand it if it
> was opposite.
>
> Thanks,
> Karmit
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Sun Jun 28 1998 - 00:00:00 CDT