Item type properties

The following table lists the Informix® data types and the values of the item type properties to which they correspond when the type tree is generated.

Informix Data Type	Interpret as	Item Subclass, Presentation	Length
BYTE	Text	Binary	^*
CHAR(n)¹	Text	Character	^*
CHARACTER(n)¹	Text	Character	^*
CHARACTER VARYING(m,r)²	Text	Character	^*
DATE	Text	Character	10
DATETIME	Text	Character	19
DEC(p,s)³	Number	Character, Decimal	^*
DECIMAL(p,s)³	Number	Character, Decimal	^*
DOUBLE PRECISION	Number	Binary, Float	8
FLOAT	Number	Binary, Float	8
INT	Number	Character, Integer	11
INTEGER	Number	Character, Integer	11
INTERVAL	Text	Character	^*
MONEY(p,s)³	Number	Character, Decimal	^*
NCHAR(n)¹	Text	Character	^*
NUMERIC(p,s)³	Number	Character, Decimal	^*
NVARCHAR(m,r)²	Text	Character	^*
REAL	Number	Binary, Float	4
SERIAL	Number	Character, Integer	11
SMALLFLOAT	Number	Binary, Float	4
SMALLINT	Number	Character, Integer	6
TEXT	Text	Binary	^*
VARCHAR(m,r)²	Text	Character	^*

^*The DBMS dictates the length of this type.

¹n=1 £ n £ 32, 67

²m=maximum size of the column: 1-255, r=minimum reserved space: 0-255; r £ m

³p=precision, s=scale