 |
c-treeACE DSQL Field Types
Type Nmemonic
|
Type Number
|
CTSQL_CHAR
|
1
|
CTSQL_NUMERIC
|
2
|
CTSQL_SMALLINT
|
3
|
CTSQL_INTEGER
|
4
|
CTSQL_SMALLFLOAT
|
5
|
CTSQL_REAL
|
6
|
CTSQL_FLOAT
|
7
|
CTSQL_DATE
|
8
|
CTSQL_MONEY
|
9
|
CTSQL_TIME
|
10
|
CTSQL_TIMESTAMP
|
11
|
CTSQL_TINYINT
|
12
|
CTSQL_BINARY
|
13
|
CTSQL_BIT
|
14
|
CTSQL_LVC
|
15
|
CTSQL_LVB
|
16
|
CTSQL_BIGINT
|
17
|
CTSQL_NCHAR*
|
18
|
CTSQL_NVARCHAR*
|
19
|
CTSQL_NCHAR_CS*
|
20
|
CTSQL_NVARCHAR_CS*
|
21
|
CTSQL_VARCHAR
|
22
|
*National character fields are only supported in the Unicode Version of c-treeACE SQL.
|
