NLS params difference

From: Maria Gurenich <gurenich_at_gmail.com>
Date: Wed, 22 Jul 2009 14:52:27 -0400
Message-ID: <ebb6b7320907221152s6635f6f8r9d043986d40c425a_at_mail.gmail.com>

Hi people.
Please, tell me what am I missing here? Did I forget something? I am not sure I am following, why it is:

14:40:48 db_manager_at_prod8> select * from NLS_DATABASE_PARAMETERS where parameter='NLS_LENGTH_SEMANTICS';

PARAMETER                      VALUE
------------------------------
---------------------------------------------------------------------------------------


*NLS_LENGTH_SEMANTICS           BYTE*

Elapsed: 00:00:00.01
14:41:34 db_manager_at_prod8> show parameter NLS_LENGTH_SEMANTICS

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------


*nls_length_semantics                 string      CHAR*

Oracle 10.2.0.4, NLS_NCHAR_CHARACTERSET=AL16UTF16

Is this normal?

Thanks,
M

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 22 2009 - 13:52:27 CDT