Name
NLS_LENGTH_SEMANTICS
Synopsis
Value: BYTE | CHAR
Default: BYTE
Dynamic: ALTER SYSTEM, ALTER SESSION
Specifies whether CHAR and VARCHAR2 columns are created with byte or character length semantics. Tables created by SYS and SYSTEM always use byte semantics. NCHAR, NVARCHAR, CLOB, and NCLOB columns are always character based. New with Oracle9i.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.