Ingres and C Data Type Compatibility

2. Embedded QUEL for C : C Variables and Data Types : Data Type Conversion : Ingres and C Data Type Compatibility

Share this page

Ingres Type	C Type
cN	char [N+1]
text(N)	char [N+1]
char(N)	char [N+1]
varchar(N)	char [N+1]
char(N)(containing ASCII null bytes)	varchar
varchar(N)(containing ASCII null bytes)	varchar
i1	short
i2	short
i4	int
f4	float
f8	double
date	char [26]
money	double

The previous table shows a choice of two possible correspondences for the char and varchar Ingres types. If there is any possibility that database columns of these types will hold ASCII null bytes, you should use the varchar type in C to represent this data.