-
Notifications
You must be signed in to change notification settings - Fork 0
Data Types
Neil Moore edited this page Oct 4, 2016
·
1 revision
The mapping of SQL data types to traditional C-style data types is as follows:
- SMALLINT
- 16-bit signed integer (int16_t)
- INT
- 32-bit signed integer (int32_t)
- BIGINT
- 64-bit signed integer (int64_t)
- DATE [YYYY, MM, DD]
- [unsigned 16-bit integer (uint16_t), unsigned 8-bit integer (uint8_t), unsigned 8-bit integer (uint8_t)]
- TIME [HH, MM, SS, TZ_HH, TZ_MM]
- [uint16_t, uint16_t, uint32_t, uint16_t, uint16_t]
- BOOLEAN
- uint8_t -> {SQL_FALSE, SQL_TRUE, SQL_UNKNOWN}