FairCom DB DSQL Field Types
| Type Mnemonic | Type Number |
|---|---|
| CTSQL_CHAR | 1 |
| CTSQL_NUMERIC | 2 |
| CTSQL_SMALLINT | 3 |
| CTSQL_INTEGER | 4 |
| CTSQL_REAL | 5 |
| CTSQL_FLOAT | 6 |
| CTSQL_DATE | 7 |
| CTSQL_MONEY | 8 |
| CTSQL_TIME | 9 |
| CTSQL_TIMESTAMP | 10 |
| CTSQL_TINYINT | 11 |
| CTSQL_BINARY | 12 |
| CTSQL_BIT | 13 |
| CTSQL_LVC | 14 |
| CTSQL_LVB | 15 |
| CTSQL_BIGINT | 16 |
| CTSQL_NCHAR* | 17 |
| CTSQL_NVARCHAR* | 18 |
| CTSQL_NCHAR_CS* | 19 |
| CTSQL_NVARCHAR_CS* | 20 |
| CTSQL_VARCHAR | 21 |
| CTSQL_BLOB | 22 |
| CTSQL_CLOB | 23 |
| CTSQL_NLVC | 24 |
| CTSQL_NCLOB | 25 |
| CTSQL_VARBINARY | 26 |
*National character fields are only supported in the Unicode version of FairCom DB SQL.
FairCom DB DSQL Transaction Isolation Levels
| CTSQL_ISOLEVEL Mnemonic | Value |
| CTSQL_READ_UNCOMMITTED* | 0 |
| CTSQL_READ_COMMITTED | 1 |
| CTSQL_REPEATABLE_READ | 2 |
| CTSQL_SERIALIZABLE* | 3 |
*Levels CTSQL_READ_UNCOMMITTED and CTSQL_SERIALIZABLE are not currently supported by FairCom DB SQL