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 |
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |