nls_paramters [message #197645] |
Thu, 12 October 2006 02:59 |
dast
Messages: 4 Registered: June 2006
|
Junior Member |
|
|
Hi whe are using oracle 9.2.0.5
i wan't to setup a new database so they can use the ¤ sign in the database.
When i look at other databases in our company i see 3 NLS parameters
select * from NLS_DATABASE_PARAMETERS;
NLS_LANGUAGE|AMERICAN
NLS_TERRITORY|AMERICA
NLS_CURRENCY|$
NLS_ISO_CURRENCY|AMERICA
NLS_NUMERIC_CHARACTERS|.,
NLS_CHARACTERSET|WE8ISO8859P1
NLS_CALENDAR|GREGORIAN
NLS_DATE_FORMAT|DD-MON-RR
NLS_DATE_LANGUAGE|AMERICAN
NLS_SORT|BINARY
NLS_TIME_FORMAT|HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT|DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT|HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT|DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY|$
NLS_COMP|BINARY
NLS_LENGTH_SEMANTICS|BYTE
NLS_NCHAR_CONV_EXCP|FALSE
NLS_NCHAR_CHARACTERSET|UTF8
NLS_RDBMS_VERSION|9.2.0.5.0
select * from NLS_INSTANCE_PARAMATERS;
NLS_LANGUAGE|AMERICAN
NLS_TERRITORY|AMERICA
NLS_SORT|
NLS_DATE_LANGUAGE|
NLS_DATE_FORMAT|
NLS_CURRENCY|
NLS_NUMERIC_CHARACTERS|
NLS_ISO_CURRENCY|
NLS_CALENDAR|
NLS_TIME_FORMAT|
NLS_TIMESTAMP_FORMAT|
NLS_TIME_TZ_FORMAT|
NLS_TIMESTAMP_TZ_FORMAT|
NLS_DUAL_CURRENCY|
NLS_COMP|
NLS_LENGTH_SEMANTICS|BYTE
NLS_NCHAR_CONV_EXCP|FALSE
select * from NLS_SESSION_PARAMETERS;
NLS_LANGUAGE|DUTCH
NLS_TERRITORY|THE NETHERLANDS
NLS_CURRENCY|¿
NLS_ISO_CURRENCY|THE NETHERLANDS
NLS_NUMERIC_CHARACTERS|,.
NLS_CALENDAR|GREGORIAN
NLS_DATE_FORMAT|DD-MM-RR
NLS_DATE_LANGUAGE|DUTCH
NLS_SORT|DUTCH
NLS_TIME_FORMAT|HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT|DD-MM-RR HH24:MI:SSXFF
NLS_TIME_TZ_FORMAT|HH24:MI:SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT|DD-MM-RR HH24:MI:SSXFF TZR
NLS_DUAL_CURRENCY|¿
NLS_COMP|BINARY
NLS_LENGTH_SEMANTICS|BYTE
NLS_NCHAR_CONV_EXCP|FALSE
What is the differnce between those parameters ?
and what characterset must i use to get the euro sign to work?
Is there an all in one character set?
Thx for your advice,
Dast
|
|
|