Use only supported ASE data types to communicate with the ASE Database.
The ASE database driver supports a number of data types. The following table lists the supported data types and how they convert to CCL types.
|
ASE v15.5 Data Type |
CCL Type |
|
REAL |
FLOAT |
|
DOUBLE PRECISION |
FLOAT |
|
DATE |
TIMESTAMP |
|
TIME |
TIMESTAMP |
|
SMALLDATETIME |
TIMESTAMP |
|
DATETIME |
TIMESTAMP |
|
SMALLMONEY |
FLOAT |
|
MONEY |
FLOAT |
|
CHAR |
STRING |
|
VARCHAR |
STRING |
|
UNICHAR |
STRING |
|
UNIVARCHAR |
STRING |
|
NCHAR |
STRING |
|
NVARCHAR |
STRING |
|
DECIMAL |
FLOAT |
|
NUMERIC |
FLOAT |
|
VARBINARY |
STRING |
|
SMALLINT |
INTEGER |
|
INTEGER |
INTEGER |
|
TINYINT |
INTEGER |
|
BIGINT |
LONG |
|
UNSIGNED SMALLINT |
INTEGER |
|
UNSIGNED INT |
INTEGER |
|
UNSIGNED BIGINT |
LONG |
|
FLOAT |
FLOAT |