| NLS_SETTINGS [message #139025] |
Mon, 26 September 2005 05:52  |
patrick
Messages: 83
Registered: December 2000
|
Member |
|
|
I have an Oracle 8.1.7 server running. With the following NLS settings on the database
SQL> select * from nls_database_parameters;
PARAMETER VALUE
------------------------------ --------------------------------
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
PARAMETER VALUE
------------------------------ --------------------------------
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_NCHAR_CHARACTERSET WE8ISO8859P1
NLS_RDBMS_VERSION 8.1.7.0.0
I am installing a new oracle server but a different version 9.2
When check the settings i get
SQL> select * from nls_database_parameters;
PARAMETER VALUE
------------------------------ ----------------------------------------
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
PARAMETER VALUE
------------------------------ ----------------------------------------
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 AL16UTF16
NLS_RDBMS_VERSION 9.2.0.1.0
The NLS_NCHAR_CHARACTERSET is different and i can't change it. I checked under the installation but there was no option.
The differences is that the Oracle 817 is running on windows 2000 and oracle 9.2 is running under windows 2003
How do i make 92 the same as 817?
THanks
|
|
|
|
| Re: NLS_SETTINGS [message #139049 is a reply to message #139025] |
Mon, 26 September 2005 07:08  |
alliejane
Messages: 59
Registered: July 2005
Location: Glasgow
|
Member |
|
|
In your 8i installation you had your National Character set as the same as your database character set..
In 9i the only options you have for the National Character Set is UNICODE AL16UTF16 or UNICODE UTF8.
This is used if you want to store additional language characters in your database (such as simplified Chinese) if you do, you create a table with NVARCHAR, NCHAR, or NCLOB.
If your not doing that, then don't worry about it.
The concept of UNICODE is that it contains every character, (special, mathematical etc) in the known world, your not going to be missing anything.
Hope that clears it up a bit...
Allie
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
