NVARCHAR2 Datatype Beginning with Oracle9i, the NVARCHAR2 datatype is redefined to be a Unicode-only datatype. When you create a table with an NVARCHAR2 column, you supply the maximum number of characters 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.The column's maximum length is determined by the national character set definition. Width specifications of character datatype NVARCHAR2 refer to the number of characters. The maximum column size allowed is 4000 bytes.
而且我们常用varchar或varchar2型的
突然又出来一个新的感觉炫的很,是吧其实,在一个新版本问世时,总要做点改动,总要有点新东东出来的啦,以告诉我们大家:看,我又弄出来一个新玩意,有时只是化妆而已;就好比我们今天穿西服,明天穿礼服一样愚见而已,交流交流
varchar2 存放本地化编码方式(如ASCII/GBK)编码的字符串。可以使用像VARCHAR2(3 CHAR)这样的声明,Oracle将留出适当的字节数来容纳基础字符集中的三个字符
是的。
Beginning with Oracle9i, the NVARCHAR2 datatype is redefined to be a Unicode-only datatype. When you create a table with an NVARCHAR2 column, you supply the maximum number of characters 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.The column's maximum length is determined by the national character set definition. Width specifications of character datatype NVARCHAR2 refer to the number of characters. The maximum column size allowed is 4000 bytes.