Product Documentation

FairCom Direct SQL for C and C++

Previous Topic

Next Topic

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.

TOCIndex