Datatype conversions from Open Client and Open Server to DB2

Table 4-4 lists the possible conversions from Open Client and Open Server datatypes to DB2 datatypes for parameters.

**Table 4-4: Datatype conversions from Open Client and Open Server to DB2**
Open Client and Open Server datatype	DB2 datatype
CS_BINARY	CHAR FOR BIT DATA (default), VARCHAR FOR BIT DATA, GRAPHIC, VARGRAPHIC, LONG VARGRAPHIC
CS_LONGBINARY	CHAR FOR BIT DATA (default), VARCHAR FOR BIT DATA, GRAPHIC, VARGRAPHIC, LONG VARGRAPHIC
CS_VARBINARY	CHAR FOR BIT DATA (default), VARCHAR FOR BIT DATA, GRAPHIC, VARGRAPHIC, LONG VARGRAPHIC
CS_BIT	SMALLINT
CS_CHAR	CHAR
CS_VARCHAR	VARCHAR
CS_LONGCHAR	CHAR (default), VARCHAR, GRAPHIC, VARGRAPHIC, LONG VARGRAPHIC
CS_DATETIME	TIMESTAMP (default), DATE, TIME
CS_DATETIME4	TIMESTAMP (default), DATE, TIME
CS_TINYINT	SMALLINT (all numeric types)
CS_SMALLINT	SMALLINT (all numeric types)
CS_INT	INT (all numeric types)
CS_DECIMAL	DECIMAL (all numeric types)
CS_NUMERIC	DECIMAL (all numeric types)
CS_FLOAT	FLOAT (all numeric types)
CS_REAL	REAL (all numeric types)
CS_MONEY	DECIMAL (all numeric types)
CS_MONEY4	DECIMAL (all numeric types)
CS_TEXT	LONG VARCHAR
CS_IMAGE	LONG VARGRAPHIC

The default DB2 type correspondence does not have to be exact. For example, DB2 accepts either CS_CHAR or CS_VARCHAR for either a DB2 CHAR or VARCHAR column. It also accepts any numeric type for any numeric column.