Supported Data Types
Supported Types
The CData ODBC Driver for Sage 300 supports the following data types as column values:
| CData Schema | ODBC Data Type |
| string | SQL_CHAR |
| string | SQL_VARCHAR |
| string | SQL_LONGVARCHAR |
| short | SQL_SMALLINT |
| int | SQL_INTEGER |
| long | SQL_BIGINT |
| float | SQL_REAL |
| double | SQL_DOUBLE |
| decimal | SQL_DECIMAL |
| boolean | SQL_BIT |
| datetime | SQL_TYPE_TIMESTAMP |
| datetime | SQL_TIMESTAMP |
| time | SQL_TYPE_TIME |
| time | SQL_TIME |