ORACLE数据库中NVARCHAR2、VARCHAR2以及VARCHAR 的区别

最新推荐文章于 2024-08-29 16:12:43 发布

海的记忆

最新推荐文章于 2024-08-29 16:12:43 发布

阅读量2.2k

点赞数

分类专栏： ORACLE基础文章标签： oracle 数据库 globalization character database performance

本文链接：https://blog.csdn.net/a3z2008/article/details/6859554

版权

ORACLE基础专栏收录该内容

17 篇文章 0 订阅

订阅专栏

NVARCHAR2 Datatype
The NVARCHAR2 datatype is a Unicode-only datatype. When youcreate a table with an NVARCHAR2 column, you supply the maximum number ofcharacters it can hold. Oracle subsequentlystores each value in the column exactly as you specify it, provided the valuedoes not exceed the maximum length of the column.

The maximum length of the column is determined by the national character setdefinition. Width specifications of character datatype NVARCHAR2 refer to thenumber of characters. The maximum column size allowed is 4000 bytes. Pleaserefer to Oracle Database Globalization Support Guide for information on Unicodedatatype support.

VARCHAR2 Datatype
The VARCHAR2 datatype specifies a variable-length characterstring. When you create a VARCHAR2 column, you supply the maximum number ofbytes or characters of data that it can hold. Oracle subsequently stores eachvalue in the column exactly as you specify it, provided the value does notexceed the column's maximum length of the column. If you try to insert a valuethat exceeds the specified length, then Oracle returns an error.

You must specify a maximum length for a VARCHAR2 column. This maximum must beat least 1 byte, although the actual string stored is permitted to be azero-length string (''). You can use the CHAR qualifier, for exampleVARCHAR2(10 CHAR), to give the maximum length in characters instead of bytes. Acharacter is technically a code point of the database character set. CHAR andBYTE qualifiers override the setting of the NLS_LENGTH_SEMANTICS parameter,which has a default of bytes. For performance reasons, Oracle recommends thatyou use the NLS_LENGTH_SEMANTICS parameter to set length semantics and that youuse the BYTE and CHAR qualifiers only when necessary to override the parameter.The maximum length of VARCHAR2 data is 4000 bytes. Oracle compares VARCHAR2values using nonpadded comparison semantics.

To ensure proper data conversion between databases with different charactersets, you must ensure that VARCHAR2 data consists of well-formed strings. SeeOracle Database Globalization Support Guide for more information on characterset support.

VARCHAR Datatype
Do not use the VARCHAR datatype. Use the VARCHAR2 datatype instead. Althoughthe VARCHAR datatype is currently synonymous with VARCHAR2, the VARCHARdatatype is scheduled to be redefined as a separate datatype used forvariable-length character strings compared with different comparison semantics.

【注释】
VARCHAR2是Oracle提供的特定数据类型，Oracle可以保证VARCHAR2在任何版本中该数据类型都可以向上和向下兼容。
VARCHAR在Oracle中不建议使用。