Sunday, 27 January 2013

How to check NLS_LENGTH_SEMANTICS


> NLS_LENGTH_SEMANTICS allows one to specify the length of a column datatype in terms of CHARacters rather than in terms of BYTEs.

> The NLS_LENGTH_SEMANTICS value found in NLS_DATABASE_PARAMETERS is the value at database creation time. This should be BYTE.

SQL> SELECT value FROM NLS_DATABASE_PARAMETERS where parameter='NLS_LENGTH_SEMANTICS';

VALUE
--------------------------------------------------------------------------------------
BYTE

SQL> SELECT value FroM V$PARAMETER WHERE NAME LIKE '%nls_length_semantics%';

VALUE
--------------------------------------------------------------------------------------
BYTE