The following macros are used by functions such as rsetnull(), risnull(), rtypalign(), rtypmsize():
Table 1. SQL Types: data type identification macros
| Macro name |
Description |
| SQLBOOL |
SQL BOOLEAN data type |
| SQLINFXBIGINT |
SQL BIGINT data type |
| SQLCHAR |
SQL CHAR data type |
| SQLSMINT |
SQL SMALLINT data type |
| SQLINT |
SQL INTEGER data type |
| SQLFLOAT |
SQL FLOAT data type |
| SQLSMFLOAT |
SQL SMALLFLOAT data type |
| SQLDECIMAL |
SQL DECIMAL data type |
| SQLSERIAL |
SQL SERIAL data type |
| SQLDATE |
SQL DATE data type |
| SQLMONEY |
SQL MONEY data type |
| SQLDTIME |
SQL DATETIME data type |
| SQLBYTES |
SQL BYTE data type |
| SQLTEXT |
SQL TEXT data type |
| SQLVCHAR |
SQL VARCHAR data type |
| SQLINTERVAL |
SQL INTERVAL data type |
| SQLNCHAR |
SQL NCHAR data type |
| SQLNVCHAR |
SQL NVARCHAR data type |
| SQLINT8 |
SQL INT8 data type |
| SQLSERIAL8 |
SQL SERIAL8 data type |
Table 2. C Types: data type identification macros
| Macro name |
Description |
| CBOOLTYPE |
C boolean data type (signed char) |
| CBIGINTTYPE |
C bigint data type (long long) |
| CCHARTYPE |
C char data type |
| CSHORTTYPE |
C short int data type |
| CINTTYPE |
C int4 data type |
| CLONGTYPE |
C long data type |
| CFLOATTYPE |
C float data type |
| CDOUBLETYPE |
C double data type |
| CDECIMALTYPE |
C dec_t data type |
| CFIXCHARTYPE |
C fixchar data type |
| CSTRINGTYPE |
C string data type |
| CDATETYPE |
C int4/date data type |
| CMONEYTYPE |
C dec_t data type |
| CDTIMETYPE |
C dtime_t data type |
| CLOCATORTYPE |
C loc_t data type |
| CVCHARTYPE |
C varchar data type |
| CINVTYPE |
C intrvl_t data type |