Ispirer Ispirer
 


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

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


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

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