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 |