Ingres Data Types - NVARCHAR

Versions: Ingres 9.x and 10.0

Ingres - NVARCHAR
Syntax	NVARCHAR(n)
Data	Variable-length character data in the predefined character set - UTF8
Parameters	n is the maximum number of characters, optional
Range	1 ⇐ n ⇐ 16000 (32000 bytes is the maximum row size shared among all columns)
Default	n is mandatory
Trailing Spaces	Not removed when the value is stored and retrieved. But trailing spaces are insignificant in comparisons, primary and unique keys
Storage Size	Actual entry length
Standards	ANSI SQL

Ingres NVARCHAR - Equivalents in Other Databases

Database	Data Type and Conversion
Oracle	NVARCHAR2(n), 1 ⇐ n ⇐ 4000/charsize, Unicode - UTF-8 or UTF-16
SQL Server	NVARCHAR(n \| max), 1 ⇐ n ⇐ 8000, 2G if max is specified, Unicode - UCS-2
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 Ingres

Data Types
Fixed-length Character Data	CHAR(n)	NCHAR(n)
Variable-length Character Data	VARCHAR(n)
Character Large Objects	TEXT(n)	LONG VARCHAR	LONG NVARCHAR

All Data Types

Oracle

SQL Server

IBM DB2

MySQL

PostgreSQL

Sybase ASE

Sybase ASA

Informix DS

Teradata

HP Neoview

Interbase/Firebird

HiRDB

Ingres