Oracle Data Types - NVARCHAR2 (zz)

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

Oracle - NVARCHAR2SyntaxNVARCHAR2(n)DataVariable-length character data in Unicode - UTF-8 or UTF-16Parametersn is the maximum number of charactersRange1 ⇐ n ⇐ 4000/charsizeDefaultn is mandatoryPaddingNot right-padded with spaces to nTrailing SpacesNot removed when the value is stored and retrievedEmpty String'' is treated as NULLError Handling Error is raised if the value is too longStorage SizeActual entry lengthSynonymsNATIONAL VARCHAR, NATIONAL CHAR VARYING, NATIONAL CHARACTER VARYINGStandardsOracle Extension

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

DatabaseData Type and ConversionSQL ServerNVARCHAR(n | max), 1 ⇐ n ⇐ 8000, 2G ifmax is specifiedMySQLNVARCHAR(n), 1 ⇐ n ⇐ 21845, Unicode - UTF-8PostgreSQLVARCHAR(n), 1 ⇐ n ⇐ 1GSybase ASENVARCHAR(n), 1 ⇐ n ⇐ pagesize/@@ncharsize (page size is 2K, 4K, 8K or 16K);UNIVARCHAR(n), 1 ⇐ n ⇐ pagesize/@@unicharsize, UnicodeInformixNVARCHAR(n,r), 1 ⇐ n ⇐ 255,LVARCHAR(n), 1 ⇐ n ⇐ 32739HP NeoviewNVARCHAR(n), 1 ⇐ n ⇐ (32708 - size of other columns)

Related Data Types in Oracle

Data TypesFixed-length Character DataCHAR(n)NCHAR(n) Variable-length Character DataVARCHAR2(n)  Character Large ObjectsCLOBNCLOBLONG//z 2012-08-01 15:29:34 IS2120@CSDN.T630071441 [T11,L241,R3,V301]