Is there any explaination from an NLS expert for this?
                    
database was created nls_length_semantics = char 
 
instance is nls_length_semantics = char
 
session is nls_length_semantics = byte
 
 
this has cause some columns to revert back to byte ..
 
SQL> select * from nls_database_parameters where parameter='NLS_LENGTH_SEMANTICS'
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_LENGTH_SEMANTICS
CHAR
1* select * from nls_database_parameters where parameter='NLS_LENGTH_SEMANTICS'
 
 
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_LENGTH_SEMANTICS
CHAR
 
 
SQL> select * from nls_session_parameters where parameter='NLS_LENGTH_SEMANTICS'
PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_LENGTH_SEMANTICS
BYTE
                
                instance is nls_length_semantics = char
session is nls_length_semantics = byte
this has cause some columns to revert back to byte ..
SQL> select * from nls_database_parameters where parameter='NLS_LENGTH_SEMANTICS'
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_LENGTH_SEMANTICS
CHAR
1* select * from nls_database_parameters where parameter='NLS_LENGTH_SEMANTICS'
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_LENGTH_SEMANTICS
CHAR
SQL> select * from nls_session_parameters where parameter='NLS_LENGTH_SEMANTICS'
PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_LENGTH_SEMANTICS
BYTE
0      
            