The identifiers returned in the TYPE_NAME and DATA_TYPE columns in the result set for sp_special_columns.
ODBC Datatype (TYPE_NAME) |
Target Datatype Length |
Datatype |
ODBC Type |
Sybase Type |
---|---|---|---|---|
BINARY |
254 |
(-2) |
SQL_BINARY |
CS_BINARY |
VARBINARY |
254 |
(-3) |
SQL_VARBINARY |
CS_VARBINARY |
LONGVARBINARY |
2^31 |
(-4) |
SQL_LONGVARBINARY |
CS_LONGBINARY |
CHAR() |
254 |
(1) |
SQL_CHAR |
CS_CHAR |
VARCHAR |
254 |
(12) |
SQL_VARCHAR |
CS_VARCHAR |
LONGVARCHAR |
2^31 |
(-1) |
SQL_LONGVARCHAR |
CS_LONGCHAR |
SMALLINT |
2 |
(5) |
SQL_SMALLINT |
CS_SMALLINT |
INTEGER |
4 |
(4) |
SQL_INTEGER |
CS_INT |
DOUBLE |
8 |
(8) |
SQL_DOUBLE |
CS_FLOAT |
FLOAT() |
8 |
(6) |
SQL_FLOAT |
CS_FLOAT |
REAL |
4 |
(7) |
SQL_REL |
CS_REAL |
DECIMAL() |
17 |
(3) |
SQL_DECIMAL |
CS_DECIMAL |
NUMERIC |
17 |
(2) |
SQL_NUMERIC |
CS_NUMERIC |
DATE |
4 |
(9) |
SQL_DATE |
CS_DATE |
TIME |
(10) |
SQL_TIME |
CS_TIME |
|
TIMESTAMP |
10 |
(11) |
SQL_TIMESTAMP |
CS_DATETIME |
TINYINT |
1 |
(-6) |
SQL_TINYINT |
CS_TINYINT |
BIGINT |
19 |
(-5) |
SQL_BIGINT |
CS_FLOAT |
BIT |
1 |
(-7) |
SQL_BIT |
CS_BIT |
GUID |
36 |
-11 |
SQL_GUID |
CS_CHAR |
WCHAR |
254 |
-8 |
SQL _WCHAR |
CS_UNICHAR |
WVARCHAR |
254 |
-9 |
SQL _WVARCHAR |
CS_UNICHAR |
WLONGVARCHAR |
230 |
-10 |
SQL _WLONGVARCHAR |
CS_UNITEXT |