Oracle9i Database Globalization Support Guide Release 2 (9.2) Part Number A96529-01 |
|
This section describes new features of globalization support in Oracle9i release 2 (9.2) and provides pointers to additional information.
The following section describes the new features in Oracle globalization support:
Oracle9i release 2 (9.2) supports Unicode 3.1.
The ALTER TABLE MODIFY
statement can be used to change column definitions from the CHAR
datatypes to the NCHAR
datatypes. It also converts the data in the columns from the CHAR
datatypes to the NCHAR
datatypes.
You can view and print code charts with Oracle Locale Builder.
Characters with diacritics can now be viewed in collation trees.
Two new parameters have been added to the Character Set Scanner: EXCLUDE
and PRESERVE
.
The TABLE
parameter has been extended to support multiple tables.
Convertible and exceptional data dictionary data are documented in the new "Data Dictionary Individual Exceptions" of the Individual Exception Report.
The members of the European Monetary Union (EMU) use the euro as their currency as of January 1, 2002. Setting NLS_TERRITORY
to correspond to a country in the EMU (Austria, Belgium, Finland, France, Germany, Greece, Ireland, Italy, Luxembourg, the Netherlands, Portugal, and Spain) results in the default values for NLS_CURRENCY
and NLS_DUAL_CURRENCY
being set to EURO
. Beginning with Oracle9i release 2 (9.2), the value of NLS_ISO_CURRENCY
results in the ISO currency symbol being set to EUR
for EMU member countries.
Use the OCIEnvNlsCreate
function to specify client-side database and national character sets when the OCI environment is created.This function allows users to set character set information dynamically in applications, independent of the NLS_LANG
and NLS_CHAR
initialization parameter settings. In addition, one application can initialize several environment handles for different client environments in the same server environment.
This function converts a string from one character set to another.
This function returns the Oracle character set ID for the specified Oracle character set name.
This function returns the Oracle character set name from the specified character set ID.
This function generates numeric language information specified by item from the OCI environment handle into an output number variable.
This function maps Oracle character set names, language names, and territory names to and from IANA and ISO names.
These APIs allow the user to specify the character set ID of BFILE
data by using a new parameter. The APIs convert the data from the specified BFILE
character set into the database character set for CLOB
s or the national character set for NCLOB
s.
You can perform a search that ignores case and diacritics.
Object Types now support NCHAR
datatypes and character semantics.
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|