Language troubles with nls lang settings
510471Aug 20 2008 — edited Aug 20 2008Hi, this is one thing that drives me crazy, any help is really appreciated. There is something sick on my computer with languages settings.
I believe the configuration is ok, check it out...
I created a DB with following encoding
EE8MSWIN1250 (MS Windows 1250)
this is what i use on client too.
SELECT * FROM NLS_DATABASE_PARAMETERS; says
PARAMETER VALUE
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET EE8MSWIN1250
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 10.2.0.1.0
while
SELECT * FROM NLS_SESSION_PARAMETERS;
PARAMETER VALUE
NLS_LANGUAGE CZECH
NLS_TERRITORY CZECH REPUBLIC
-- this is the problem here
-- this is the problem, it should be Kč
NLS_CURRENCY Kè
--
NLS_ISO_CURRENCY CZECH REPUBLIC
NLS_NUMERIC_CHARACTERS ,.
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD.MM.RR
NLS_DATE_LANGUAGE CZECH
If I go to sqlplus
L:\>set NLS_LANG=CZECH_CZECH REPUBLIC.EE8PC852
L:\>sqlplus system/nlslang@nlslang
SQL*Plus: Release 10.2.0.1.0 - Production on St Srp 20 13:25:00 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
P²ipojeno k:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
Problem comes with "Připojeno" (bold above)
The problem is only with my laptop, if I try it on different computer, connect to the same DB it works fine...
C:\>sqlplus system/nlslang@nlslang
SQL*Plus: Release 10.2.0.1.0 - Production on St Srp 20 14:06:47 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Připojeno k:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
So I guess DB setting must be OK and there is something sick with my windows XP Profesional version 2002, service pack 2. so may be this is not the proper place to ask for help but had you have any suggestions what could be wrong, tell me.
Karel