Ingres Data Types - VARCHAR

Versions: Ingres 9.x and 10.0

Ingres - VARCHAR
Syntax	VARCHAR(n)
Data	Variable-length character data, single-byte and multibyte character sets
Parameters	n is the maximum number of characters, optional
Range	1 ⇐ n ⇐ 32000
Default	n is mandatory
Padding	Not right-padded with spaces to n
Trailing Spaces	Not removed when the value is stored and retrieved. But trailing spaces are insignificant in comparisons, primary and unique keys
Storage Size	Actual entry length
Standards	ANSI SQL

Ingres VARCHAR - Equivalents in Other Databases

Database	Data Type and Conversion
Oracle	VARCHAR2(n), 1 ⇐ n ⇐ 4000/charsize
SQL Server	VARCHAR(n \| max), 1 ⇐ n ⇐ 8000, 2G if max is specified
IBM DB2	VARCHAR(n), 1 ⇐ n ⇐ 32672
MySQL	VARCHAR(n), 1 ⇐ n ⇐ 65535/charsize
PostgreSQL	VARCHAR(n), 1 ⇐ n ⇐ 1G
Sybase ASE	VARCHAR(n), 1 ⇐ n ⇐ pagesize (2K, 4K, 8K or 16K)
Sybase ASA	VARCHAR(n), 1 ⇐ n ⇐ 32767/charsize
Informix	VARCHAR(n, r), 1 ⇐ n ⇐ 255, LVARCHAR(n), 1 ⇐ n ⇐ 32739
Teradata	VARCHAR(n), 1 ⇐ n ⇐ 64000/charsize
HP Neoview	VARCHAR(n), 1 ⇐ n ⇐ (32708 - size of other columns)
Interbase/Firebird	VARCHAR(n), 1 ⇐ n ⇐ 32765/charsize

Related Data Types in Ingres

Data Types
Fixed-length Character Data	CHAR(n)	NCHAR(n)
Variable-length Character Data	NVARCHAR(n)
Character Large Objects	TEXT(n)	LONG VARCHAR	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