varchar2(10 byte)和varchar2(10 char)有什么不同
来源:互联网 发布:23code 项目源码 编辑:程序博客网 时间:2024/05/21 15:44
The VARCHAR2 datatype specifies a variable-length character string. When you create a VARCHAR2 column, you supply the maximum number of bytes or characters of data that it can hold. Oracle subsequently stores each value in the column exactly as you specify it, provided the value does not exceed the column's maximum length of the column. If you try to insert a value that exceeds the specified length, then Oracle returns an error.
You must specify a maximum length for a VARCHAR2 column. This maximum must be at least 1 byte, although the actual string stored is permitted to be a zero-length string (''). You can use the CHAR qualifier, for example VARCHAR2(10 CHAR), to give the maximum length in characters instead of bytes. A character is technically a code point of the database character set. CHAR and BYTE qualifiers override the setting of the NLS_LENGTH_SEMANTICS parameter, which has a default of bytes. For performance reasons, Oracle recommends that you use the NLS_LENGTH_SEMANTICS parameter to set length semantics and that you use the BYTE and CHAR qualifiers only when necessary to override the parameter. The maximum length of VARCHAR2 data is 4000 bytes. Oracle compares VARCHAR2 values using nonpadded comparison semantics.
转自:http://blog.csdn.net/haydenwang8287/article/details/3899954
- varchar2(10 byte)和varchar2(10 char)有什么不同
- varchar2(10 byte)和varchar2(10 char)有什么不同
- Oracle - char, nchar,varchar,varchar2(byte), varchar2(char) 和 nvarchar2
- varchar2(10)和varchar2(10 char)的区别
- varchar2的参数(byte和char)
- varchar2的参数(byte和char)区别
- varchar2的参数(byte和char)区别
- Oracle varchar2(Byte)与varchar2(Char)
- char varchar varchar2(byte) varchar(char) nvarchar2()有何不同?
- varchar2(10)和varchar2(1000)的区别
- varchar2(10)和varchar2(1000)的区别
- char和varchar2
- char和varchar2对比
- oracle 10g varchar2与varchar有什么区别
- mysql的varchar(20)和oracle的varchar2(20)有什么不同?
- char(10)、varchar2(10)、nvarchar2(10) 区别
- char和varchar2的区别
- char和varchar2的区别
- 独立函数
- 构建高可扩Web架构和分布式系统实战
- memset、memset、strcpy函数详细说明
- android的文件操作
- 创建物化视图例子
- varchar2(10 byte)和varchar2(10 char)有什么不同
- C#中对winform的控件datagridview直接进行编辑,修改,删除操作注意的地方
- 黑马程序员—泛型
- SQL
- 《精通HTML5 + CSS3+JavaScript网页设计》
- 位运算1
- 结构体数组初始化
- 黑马程序员-java 枚举
- Myeclipse8.5中svn插件安装方法总结