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.
This Client-Library datatype |
Whose datatype declaration looks like this |
Describes this type of data |
Corresponds to this Adaptive Server datatype |
Corresponds to this Open ServerConnect datatype |
---|---|---|---|---|
CS_BINARY |
CHAR(n) |
Binary |
Binary |
TDSBINARY |
CS_CHAR |
CHAR(n) |
Character |
Char |
TDSCHAR |
CS_DATETIME |
CHAR(8) |
8-byte datetime |
Datetime |
TDSDATETIME |
CS_DATETIME4 |
CHAR(4) |
4-byte datetime |
Smalltime |
TDSDATETIME4 |
CS_FLOAT |
FLOAT DEC(n) |
8-byte float |
Float |
TDSFLT8 |
CS_INT |
FIXED BIN(31) |
4-byte integer |
int |
TDSINT4 |
CS_LONGBINARY |
CHAR (n) |
Long variable binary |
-- |
TDSLONGVARBIN |
CS_LONGCHAR |
CHAR (n) |
Long variable character |
-- |
TDSLONGVARCHAR |
CS_MONEY |
FIXED DEC(p,s) |
8-byte money |
money |
TDSMONEY |
CS_MONEY4 |
FIXED DEC(p,s) |
4-byte money |
smallmoney |
TDSMONEY4 |
CS_PACKED370 |
FIXED DEC(p,s) |
IBM S/370 packed decimal |
decimal |
TDS_PACKED_ DECIMAL |
CS_REAL |
FLOAT DEC() |
4-byte float |
real |
TDSFLT4 |
CS_SMALLINT |
FIXED BIN(15) |
2-byte integer |
smallint |
TDSINT2 |
CS_VARBINARY |
BIT(n) VAR |
Variable-length binary |
-- |
TDSVARYBIN |
CS_VARCHAR |
CHAR(n) VAR |
Variable-length character |
-- |
TDSVARYCHAR |
CS_NUMERIC |
CHAR (35) |
-- |
numeric |
TDSNUMERIC |
CS_DECIMAL |
CHAR (35) |
-- |
Sybase decimal |
TDS_SYBASE_DECIMAL |