Ispirer Website Ispirer Capabilities - Ingress Migration Free Trial

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


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.