oracle tovarchar2_Oralce中VARCHAR2()与NVARCHAR2()的区别介绍

一、先来看看Oralce中VARCHAR2()和NVARCHAR2()的官方定义

官方文档定义如下：

VARCHAR2(size [BYTE | CHAR])

Variable-length character string having maximum length size bytes or characters. Maximum size is 4000 bytes or characters, and minimum is 1 byte or 1 character. You must specify size for VARCHAR2.

BYTE indicates that the column will have byte length semantics. CHAR indicates that the column will have character semantics.

NVARCHAR2(size)

Variable-length Unicode character string having maximum length size characters. The number of bytes can be up to two times size for AL16UTF16 encoding and three times size for UTF8 encoding. Maximum size is determined by the national character set definition, with an upper limit of 4000 bytes. You must specify size for NVARCHAR2.

二、中文翻译：

VARCHAR2(size [BYTE | CHAR])

具有最大长度的字节数(bytes)或字符数(char)的可变长度的字符类型。最大长度为4000字节/字符，最小长度是1字节/字符。你必须为VARCHA