设置oracle的CHAR或VARCHAR2类型是按位数还是按字节数存放字符串:
ALTER SYSTEM SET NLS_LENGTH_SEMANTICS = 'CHAR' SCOPE = spfile;
ALTER SYSTEM SET NLS_LENGTH_SEMANTICS = 'BYTE' SCOPE = spfile;
------------------------------------------------------------------
执行顺序:
先用sys用户执行以上设置之后,在建其他用户,在建表,否则反映不到建的表中。
------------------------------------------------------------------
查看当前的设置
select * from nls_instance_parameters where parameter='NLS_LENGTH_SEMANTICS';
select * from nls_session_parameters where parameter='NLS_LENGTH_SEMANTICS';
select * from nls_database_parameters where parameter='NLS_LENGTH_SEMANTICS';
或 SHOW PARAMETERS NLS_LENGTH_SEMANTICS;