Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02 |
|
Initialization Parameters, 120 of 220
Parameter type |
String |
Syntax |
Example: |
Default value |
|
Parameter class |
Dynamic: |
Range of values |
|
NLS_LENGTH_SEMANTICS
enables you to create CHAR
and VARCHAR2
columns using either byte or character length semantics. Existing columns are not affected.
Databases should use byte semantics rather than character semantics if they have a variable-width multibyte character set. All other databases should be created or eventually migrated to character semantics. Old databases using unmodified old applications should use byte semantics.
NLS_LENGTH_SEMANTICS
does not apply to tables in SYS
and SYSTEM
. The data dictionary will always use byte semantics regardless. Also, NCHAR
, NVARCHAR
, CLOB
, and NCLOB
are always character-based.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|