nls_length_semantics showing different Values!

From: edwin devadanam <edwin_kodamala_at_yahoo.com>
Date: Thu, 9 Aug 2007 05:04:14 -0700 (PDT)
Message-ID: <524365.78042.qm@web52002.mail.re2.yahoo.com>

Hi,    

  O/S is HP-UX        

  1)select * from nls_database_parameters; NLS_LENGTH_SEMANTICS CHAR       2)select * from V$nls_parameters;
NLS_LENGTH_SEMANTICS BYTE       3)In init.ora it is
  nls_length_semantics = BYTE        

  ours is 10.2.0.2        

  why is this difference?        

  Regards,
Edwin.K        

---

Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV.
--

http://www.freelists.org/webpage/oracle-l Received on Thu Aug 09 2007 - 07:04:14 CDT