ITPub博客

首页 > Linux操作系统 > Linux操作系统 > NLS_LENGTH_SEMANTICS(转)

NLS_LENGTH_SEMANTICS(转)

原创 Linux操作系统 作者:tochar 时间:2007-07-26 00:00:00 0 删除 编辑

NLS_LENGTH_SEMANTICS

Parameter type

String

Syntax

NLS_LENGTH_SEMANTICS = string

Example: NLS_LENGTH_SEMANTICS = 'CHAR'

Default value

BYTE

Parameter class

Dynamic: ALTER SESSION, ALTER SYSTEM

Range of values

BYTE | CHAR

NLS_LENGTH_SEMANTICS enables you to create CHAR and VARCHAR2 columns using either byte or character length semantics. Existing columns are not affected.

NCHAR, NVARCHAR2, CLOB, and NCLOB columns are always character-based. You may be required to use byte semantics in order to maintain compatibility with existing applications.

NLS_LENGTH_SEMANTICS does not apply to tables in SYS and SYSTEM. The data dictionary always uses byte semantics.


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9078678/viewspace-45118/,如需转载,请注明出处,否则将追究法律责任。

上一篇: NLS_LANGUAGE(转)
请登录后发表评论 登录
全部评论

注册时间:2007-12-11

  • 博文量
    118
  • 访问量
    790678