Oracle的NLS_LENGTH_SEMANTICS参数决定了VARCHAR2、CHAR等数据类型的长度单位，默认是BYTE，但建议显式使用CHAR。该参数影响会话级别和实例级别，对创建对象时的长度解析有重要影响，特别是多字节字符集环境下。Oracle警告不要在实例级别设置为CHAR，以免引起现有脚本错误和运行时问题。
NLS_LENGTH_SEMANTICS
Property
Description
Parameter
type
String
Syntax
NLS_LENGTH_SEMANTICS =
string
Example: NLS_LENGTH_SEMANTICS = 'CHAR'
Default
value
BYTE
Modifiable
ALTER
SESSION
Range of
values
BYTE |
CHAR
The session-level value of NLS_LENGTH_SEMANTICS
specifies the default length semantics to use for
VARCHAR2 and CHAR table columns,
user-defined object attributes, and PL/SQL variables in database
objects created in the session. This default may be overridden by
the explicit length semantics qualifiers BYTE and
CHAR in column, attribute, and variable
definitions.
会话级别的nls_length_semantics说明默认的char和varchar2，用户定义的对象属性，和pl/sql变量在数据库对象创建的长度语法。默认值会被显示说明的参数值覆盖。
The instance-level value of NLS_LENGTH_SEMANTICS
provides a default for the session-level value if
NLS_LENGTH_SEMANTICS it is not set explicitly by the
database client through the NLS_LENGTH_SEMANTICS
client environment variable (does not apply to JDBC Thin clients),
or the ALTER SESSION SET
NLS_LENGTH_S
最低0.47元/天 解锁文章
7866
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
