Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Database Migration Request SQLWays

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


Ispirer Home Page Ispirer SQLWays Product Page - Database Migration Request SQLWays

sqlways/ingres/data-types/long_varchar.txt · Last modified: May 07, 2018, 03:15:28 PM (external edit)
 
© 1999-2022, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement