|
When you issue a CREATE TABLE statement, SQL Anywhere automatically converts the data types to the corresponding Adaptive Server Enterprise data types. The following table describes the SQL Anywhere to Adaptive Server Enterprise data type conversions.
| SQL Anywhere data type | Adaptive Server Enterprise default data type |
|---|---|
| Bit | bit |
| Tinyint | tinyint |
| Smallint | smallint |
| Int | int |
| Integer | integer |
| decimal [defaults p=30, s=6] | numeric(30,6) |
| decimal(128,128) | not supported |
| numeric [defaults p=30 s=6] | numeric(30,6) |
| numeric(128,128) | not supported |
| Float | real |
| Real | real |
| Double | float |
| Smallmoney | numeric(10,4) |
| Money | numeric(19,4) |
| Date | datetime |
| Time | datetime |
| Timestamp | datetime |
| Smalldatetime | datetime |
| Datetime | datetime |
| char(n) | varchar(n) |
| Character(n) | varchar(n) |
| varchar(n) | varchar(n) |
| Character varying(n) | varchar(n) |
| long varchar | text |
| Text | text |
| binary(n) | binary(n) |
| long binary | image |
| Image | image |
| Bigint | numeric(20,0) |