Oracle Data Types - NVARCHAR2 (zz)

Versions: Oracle 11g, 10g, 9i, 8i and 7.3

Oracle - NVARCHAR2
Syntax	NVARCHAR2(n)
Data	Variable-length character data in Unicode - UTF-8 or UTF-16
Parameters	n is the maximum number of characters
Range	1 ⇐ n ⇐ 4000/charsize
Default	n is mandatory
Padding	Not right-padded with spaces to n
Trailing Spaces	Not removed when the value is stored and retrieved
Empty String	'' is treated as NULL
Error Handling	Error is raised if the value is too long
Storage Size	Actual entry length
Synonyms	NATIONAL VARCHAR, NATIONAL CHAR VARYING, NATIONAL CHARACTER VARYING
Standards	Oracle Extension

Oracle NVARCHAR2 - Equivalents in Other Databases //z 2012-08-01 15:29:34 IS2120@CSDN.T630071441 [T11,L241,R3,V301]

Database	Data Type and Conversion
SQL Server	NVARCHAR(n | max), 1 ⇐ n ⇐ 8000, 2G ifmax is specified
MySQL	NVARCHAR(n), 1 ⇐ n ⇐ 21845, Unicode - UTF-8
PostgreSQL	VARCHAR(n), 1 ⇐ n ⇐ 1G
Sybase ASE	NVARCHAR(n), 1 ⇐ n ⇐ pagesize/@@ncharsize (page size is 2K, 4K, 8K or 16K);UNIVARCHAR(n), 1 ⇐ n ⇐ pagesize/@@unicharsize, Unicode
Informix	NVARCHAR(n,r), 1 ⇐ n ⇐ 255,LVARCHAR(n), 1 ⇐ n ⇐ 32739
HP Neoview	NVARCHAR(n), 1 ⇐ n ⇐ (32708 - size of other columns)

Related Data Types in Oracle

Data Types
Fixed-length Character Data	CHAR(n)	NCHAR(n)
Variable-length Character Data	VARCHAR2(n)
Character Large Objects	CLOB	NCLOB	LONG

//z 2012-08-01 15:29:34 IS2120@CSDN.T630071441 [T11,L241,R3,V301]