Ingres Data Types - LONG VARCHAR

Versions: Ingres 9.x and 10.0

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

Ingres LONG VARCHAR - Equivalents in Other Databases

Database	Data Type and Conversion
Oracle	CLOB, 4G; NCLOB, 4G, Unicode - UTF-8 or UTF-16
SQL Server	VARCHAR(max) or TEXT, 2G
MySQL	LONGTEXT, 4G
PostgreSQL	TEXT, 1G
Sybase ASE	TEXT, 2G
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 NVARCHAR

All Data Types

Oracle

SQL Server

IBM DB2

MySQL

PostgreSQL

Sybase ASE

Sybase ASA

Informix DS

Teradata

HP Neoview

Interbase/Firebird

HiRDB

Ingres