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