Oracle Nvchar2 and VARCHAR2 differential analysis

Oracle Nvchar2 and VARCHAR2 differential analysis:

Note
VARCHAR2 is a specific data type provided by Oracle, and Oracle can guarantee that the data type is up and backwards compatible in any version of VARCHAR2.
VarChar is not recommended for use in Oracle.

Specific to the difference between NVARCHAR2 and VARCHAR2, from the point of view of the difference is: NVARCHAR2 in the calculation of length and character sets, such as the database is the Chinese character set with length 10 for example, then

1, NVARCHAR2 (10) is can be stored in 10 Chinese characters, if used to save English can only save 10 characters.

2, and VARCHAR2 (10), then only 5 characters can be stored in English, 10.

From

Http://www.cnblogs.com/lovewife/articles/2467663.html

http://apps.hi.baidu.com/share/detail/18768651

Http://www.cnblogs.com/flyingfish/archive/2010/01/15/1648448.html

Oracle Nvchar2 and VARCHAR2 differential analysis