Ingres and BASIC Data Type Compatibility

The following table shows the default type compatibility for each Ingres data type. Note that some BASIC types do not match exactly and, consequently, can go through some runtime conversion.

Ingres Type	BASIC Type
char(N)	string (dynamic)
char(N)	string (static with length clause of N)
varchar(N)	string (dynamic)
varchar(N)	string (static with length clause of N)
integer1	integer byte
smallint	integer word
integer	integer long
float4	real single
float	real double
date	string (dynamic)
date	string (static with length clause of 25)
money	real double
table_key	string (dynamic)
table_key	string (static with length clause of 8)
object_key	string (dynamic)
object_key	string (static with length clause of 16)
decimal	real double
long varchar	string (dynamic)