Datatypes

Description

Open ClientConnect supports a wide range of datatypes. These datatypes are shared with Open Client, Open Server and Open ServerConnect, and correspond directly to Adaptive Server datatypes.

Table 2-7 lists the Client-Library datatypes, together with the corresponding type constants, Adaptive Server datatypes, and Open ServerConnect datatypes.

**Table 2-7: Summary of Open ClientConnect datatypes**
This Client-Library datatype	Describes this type of data	Corresponds to this Adaptive Server datatype	Corresponds to this Open ServerConnect datatype
CS_BINARY	Binary	binary	TDSBINARY
CS_CHAR	Character	char	TDSCHAR
CS_DATETIME	8-byte datetime	datetime	TDSDATETIME
CS_DATETIME4	4-byte datetime	smalldatetime	TDSDATETIME4
CS_FLOAT	8-byte float	float	TDSFLT8
CS_INT	4-byte integer	int	TDSINT4
CS_LONGBINARY	Long variable binary	– –	TDSLONGVARBIN
CS_LONGCHAR	Long variable character	– –	TDSLONGVARCHAR
CS_MONEY	8-byte money	money	TDSMONEY
CS_MONEY4	4-byte money	smallmoney	TDSMONEY4
CS_PACKED370	IBM S/370 packed decimal	decimal	TDS_PACKED_DECIMAL
CS_REAL	4-byte float	real	TDSFLT4
CS_SMALLINT	2-byte integer	smallint	TDSINT2
CS_VARBINARY	Variable-length binary	– –	TDSVARYBIN
CS_VARCHAR	Variable-length character	– –	TDSVARYCHAR
CS_NUMERIC		numeric	TDSNUMERIC
CS_DECIMAL		Sybase decimal	TDS_SYBASE_DECIMAL