Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle-l »

nls_length_semantics showing different Values!

edwin devadanam

2007-08-09

Replies:

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.
©2008 dba.5341.com - Jax Systems, LLC, U.S.A.