When you issue a CREATE TABLE statement, SQL Anywhere automatically converts the data types to the corresponding Advantage Database Server data types using the following data type conversions.
SQL Anywhere data type | ADS default data type |
---|---|
BIT | Logical |
TINYINT, SMALLINT, INT, INTEGER | Integer |
BIGINT | Numeric(32) |
DECIMAL(p,s), NUMERIC(p,s) | Numeric(p+3) |
DATE | Date |
TIME | Time |
DATETIME, TIMESTAMP | TimeStamp |
MONEY, SMALLMONEY | Money |
FLOAT, REAL | Double |
CHAR(n), VARCHAR(n), LONG VARCHAR | Char(n) |
BINARY(n), VARBINARY(n), LONG BINARY | Blob |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |