When importing tables from another GDBase database the types are preserved without any changes.
When a table is imported using ODBC drivers, the data is first mapped into one of general SQL types, which are subsequently converted into one of GDBase basic types according to the following type conversion table:
Table 44.1. ODBC Import type conversions
| SQL type | GDBase type |
|---|---|
| SQL_GUID | TEXT |
| SQL_CHAR | |
| SQL_VARCHAR | |
| SQL_LONGVARCHAR | |
| SQL_WCHAR | |
| SQL_WVARCHAR | |
| SQL_WLONGVARCHAR | |
| SQL_DECIMAL | REAL |
| SQL_NUMERIC | |
| SQL_REAL | |
| SQL_FLOAT | |
| SQL_DOUBLE | |
| SQL_SMALLINT | INTEGER |
| SQL_INTEGER | |
| SQL_TINYINT | |
| SQL_BIT | |
| SQL_BIGINT | |
| SQL_TYPE_DATE | DATE |
| SQL_TYPE_TIME | TIME |
| SQL_TYPE_TIMESTAMP | DATETIME |
For other data types the behavior depends on the specification in the ON ERROR clause.