Ingres Data Types - LONG NVARCHAR

Versions: Ingres 9.x and 10.0

Ingres - LONG NVARCHAR
Syntax	LONG NVARCHAR
Data	Variable-length character data in the predefined character set - UTF8
Range	2G
Notes	These columns cannot be directly compared to other string data types. To compare a long nvarchar column to another string data type, apply a coercion function. A string literal of more than 1000 characters cannot be assigned to a long nvarchar column.
Standards	ANSI SQL

Ingres LONG NVARCHAR - Equivalents in Other Databases

Database	Data Type and Conversion
Oracle	NVARCHAR2(n), 1 ⇐ n ⇐ 4000/charsize, Unicode - UTF-8 or UTF-16; NCLOB, 4G, Unicode - UTF-8 or UTF-16
SQL Server	NVARCHAR(n \| max), 1 ⇐ n ⇐ 4000, 2G if max is specified
MySQL	LONGTEXT, 4G
PostgreSQL	TEXT, 1G
Sybase ASE	UNITEXT, 2G, Unicode
Informix	TEXT, 2G, CLOB, 4T
HP Neoview	VARCHAR(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)	NVARCHAR(n)
Character Large Objects	TEXT(n)	LONG VARCHAR

All Data Types

Oracle

SQL Server

IBM DB2

MySQL

PostgreSQL

Sybase ASE

Sybase ASA

Informix DS

Teradata

HP Neoview

Interbase/Firebird

HiRDB

Ingres