The following table shows corresponding Open Client and Open Server and Adaptive Server datatypes.
Open Client and Open Server datatype |
Corresponding Adaptive Server datatype |
|---|---|
CS_BINARY |
binary, varbinary |
CS_LONGBINARY |
NONE |
CS_BIT |
bit |
CS_CHAR |
char |
CS_VARCHAR |
varchar |
CS_LONGCHAR |
NONE |
CS_DATETIME |
datetime |
CS_DATETIME4 |
smalldatetime |
CS_TINYINT |
tinyint |
CS_SMALLINT |
smallint |
CS_INT |
int |
CS_DECIMAL |
decimal |
CS_NUMERIC |
numeric |
CS_FLOAT |
float |
CS_REAL |
real |
CS_MONEY |
money |
CS_MONEY4 |
smallmoney |
CS_TEXT |
text |
CS_IMAGE |
image |
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
