Host variable datatypes must be compatible with the datatypes of the corresponding database columns. So, before writing your application program, check the datatypes of the database columns. To ensure that your host variables are compatible with the Adaptive Server Enterprise datatypes, use the Sybase-supplied type definitions.
Table 4-4 shows and briefly describes the equivalent datatypes. For detailed descriptions of each Adaptive Server Enterprise datatype, see the Adaptive Server Enterprise Reference Manual.
Sybase-supplied typedef |
Description |
C datatype |
Adaptive Server Enterprise datatype |
---|---|---|---|
CS_BIGINT |
8-byte integer type |
long long |
bigint |
CS_BINARY |
Binary type |
unsigned char |
binary, varbinary |
CS_BIT |
Bit type |
unsigned char |
boolean |
CS_CHAR |
Character type |
char[n] |
char, varchar |
CS_DATE |
4-byte date type |
None |
date |
CS_TIME |
4-byte time type |
None |
time |
CS_DATETIME |
8-byte datetime type |
None |
datetime |
CS_DATETIME4 |
4-byte datetime type |
None |
smalldatetime |
CS_BIGDATETIME |
8-byte binary type |
None |
bigdatetime |
CS_BIGTIME |
8-byte binary type |
None |
bigtime |
CS_TINYINT |
1-byte unsigned integer type |
unsigned char |
tinyint |
CS_SMALLINT |
2-byte integer type |
short |
smallint |
CS_INT |
4-byte integer type |
long |
int |
CS_DECIMAL |
Decimal type |
None |
decimal |
CS_NUMERIC |
Numeric type |
None |
numeric |
CS_FLOAT |
8-byte float type |
double |
float |
CS_REAL |
4-byte float type |
float |
real |
CS_MONEY |
8-byte money type |
None |
money |
CS_MONEY4 |
4-byte money type |
None |
smallmoney |
CS_TEXT |
Text type -y option required |
unsigned char |
text |
CS_IMAGE |
Image type -y option required |
unsigned char |
image |
CS_UBIGINT |
8-byte unsigned integer type |
unsigned long long |
ubigint |
CS_UINT |
4-byte unsigned integer type |
unsigned int |
uint |
CS_UNICHAR |
2-byte UTF-16 Unicode character type |
unsigned short |
unichar |
CS_UNITEXT |
2-byte UTF-16 Unicode text type |
unsigned short |
unitext |
CS_USMALLINT |
2-byte unsigned integer type |
unsigned short |
usmallint |
CS_XML |
XML type |
unsigned char |
xml |