Different displays for spanish accents and Ñ letter
anaMay 15 2012 — edited May 23 2012Hi,
I'm having some problems with spanish accents plus the ñ letter:
If I introduce new rows from the SQL*Plus installed as part of the DB server installation, I can see them right : for example: Comprobación ñ
through a Windows client SQL*Developer
through the EM Console
through the OWB
I see them wrongly through the Windows client SQL*Plus installation: Comprobaci¾n ±
If I introduce new rows from the SQL*Plus installed as part of a client installation in Windows (Ñandú) , I see them wrongly in all the previous tools,SQL*Developer, OWB, OEM, SQL*Plus of the server (¥and£).
If I execute: select ascii (valores) from prueba; I see the same code in all the tools.
OS: Red Hat Linux 5.0
Oracle Server: 11.2.0.2.0
NLS Database Server:
NLS_LANGUAGE: SPANISH
NLS_TERRITORY: SPAIN
Server Environment Variable:
NLS_LANG= SPANISH_SPAIN.AL32UTF8
Windows registry (access through SQL*Plus)
NLS_LANG: SPANISH_SPAIN.WE8MSWIN1252
Some views from the Windows SQL*Plus client:
SQL> select sys_context('userenv','language') from dual;
SYS_CONTEXT('USERENV','LANGUAGE')
------------------------------------------------------------
SPANISH_SPAIN.AL32UTF8
SQL> SELECT * FROM NLS_SESSION_PARAMETERS;
PARAMETER
-------------------------------------------------------------
VALUE
-------------------------------------------------------------
NLS_LANGUAGE
SPANISH
NLS_TERRITORY
SPAIN
NLS_CURRENCY
Ç
PARAMETER
-------------------------------------------------------------
VALUE
-------------------------------------------------------------
NLS_ISO_CURRENCY
SPAIN
NLS_NUMERIC_CHARACTERS
,.
NLS_CALENDAR
GREGORIAN
PARAMETER
-------------------------------------------------------------
VALUE
-------------------------------------------------------------
NLS_DATE_FORMAT
DD/MM/RR
NLS_DATE_LANGUAGE
SPANISH
NLS_SORT
SPANISH
PARAMETER
-------------------------------------------------------------
VALUE
-------------------------------------------------------------
NLS_TIME_FORMAT
HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT
DD/MM/RR HH24:MI:SSXFF
NLS_TIME_TZ_FORMAT
HH24:MI:SSXFF TZR
PARAMETER
-------------------------------------------------------------
VALUE
-------------------------------------------------------------
NLS_TIMESTAMP_TZ_FORMAT
DD/MM/RR HH24:MI:SSXFF TZR
NLS_DUAL_CURRENCY
Ç
NLS_COMP
BINARY
PARAMETER
-------------------------------------------------------------
VALUE
-------------------------------------------------------------
NLS_LENGTH_SEMANTICS
BYTE
NLS_NCHAR_CONV_EXCP
FALSE
Same views from the Linux SQL*Plus client:
SQL> select sys_context('userenv','language') from dual;
SYS_CONTEXT('USERENV','LANGUAGE')
------------------------------------------------------------
SPANISH_SPAIN.AL32UTF8
SQL> SELECT * FROM NLS_SESSION_PARAMETERS;
PARAMETER
-------------------------------------------------------------
VALUE
-------------------------------------------------------------
NLS_LANGUAGE
SPANISH
NLS_TERRITORY
SPAIN
NLS_CURRENCY
€
PARAMETER
-------------------------------------------------------------
VALUE
-------------------------------------------------------------
NLS_ISO_CURRENCY
SPAIN
NLS_NUMERIC_CHARACTERS
,.
NLS_CALENDAR
GREGORIAN
PARAMETER
-------------------------------------------------------------
VALUE
-------------------------------------------------------------
NLS_DATE_FORMAT
DD/MM/RR
NLS_DATE_LANGUAGE
SPANISH
NLS_SORT
SPANISH
PARAMETER
-------------------------------------------------------------
VALUE
-------------------------------------------------------------
NLS_TIME_FORMAT
HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT
DD/MM/RR HH24:MI:SSXFF
NLS_TIME_TZ_FORMAT
HH24:MI:SSXFF TZR
PARAMETER
-------------------------------------------------------------
VALUE
-------------------------------------------------------------
NLS_TIMESTAMP_TZ_FORMAT
DD/MM/RR HH24:MI:SSXFF TZR
NLS_DUAL_CURRENCY
€
NLS_COMP
BINARY
PARAMETER
-------------------------------------------------------------
VALUE
-------------------------------------------------------------
NLS_LENGTH_SEMANTICS
BYTE
NLS_NCHAR_CONV_EXCP
FALSE
The only difference I may see is related to the euro symbol, that it isn`t correctly displayed in the windows SQL*Plus.
What I think is happening with accents and ñ letter (maybe I´m wrong because this area is quite confusing for me) is that for some reason the database server understands that the information sent by the Windows SQL*Plus client has not to be translated (as if it was in AL32UTF8, not in WE8MSWIN1252), which is not correct, so, what else should I configure in my client installation in Windows for it to work properly?
Thanks,
Ana