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.
- Why I have a difference between the registry and SQL*Plus?
- 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.