NLS

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')

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