CCI_U_TYPE_NULL |
0 |
CCI_U_TYPE_CHAR |
1 |
CCI_U_TYPE_STRING |
2 |
CCI_U_TYPE_NCHAR |
3 |
CCI_U_TYPE_VARNCHAR |
4 |
CCI_U_TYPE_BIT |
5 |
CCI_U_TYPE_VARBIT |
6 |
CCI_U_TYPE_NUMERIC |
7 |
CCI_U_TYPE_INT |
8 |
CCI_U_TYPE_SHORT |
9 |
CCI_U_TYPE_MONETARY |
10 |
CCI_U_TYPE_FLOAT |
11 |
CCI_U_TYPE_DOUBLE |
12 |
CCI_U_TYPE_DATE |
13 |
CCI_U_TYPE_TIME |
14 |
CCI_U_TYPE_TIMESTAMP |
15 |
CCI_U_TYPE_SET |
16 |
CCI_U_TYPE_MULTISET |
17 |
CCI_U_TYPE_SEQUENCE |
18 |
CCI_U_TYPE_OBJECT |
19 |
↓
0 |
A |
B |
X X X X X |
A |
B |
|
0 |
0 |
|
0 |
1 |
SET |
1 |
0 |
MULTISET |
1 |
1 |
SEQUENCE |
CUBRID Type |
Type def |
T_CCI_ATYPE |
C data type |
---|---|---|---|
CHAR |
CCI_U_TYPE_CHAR |
CCI_A_TYPE_STR |
char* |
VARCHAR |
CCI_U_TYPE_STRING |
CCI_A_TYPE_STR |
char* |
NCHAR |
CCI_U_TYPE_NCHAR |
CCI_A_TYPE_STR |
char* |
NCHAR VARYING |
CCI_U_TYPE_VARNCHAR |
CCI_A_TYPE_STR |
char* |
BIT |
CCI_U_TYPE_BIT |
CCI_A_TYPE_BIT |
T_CCI_BIT* |
BIT VARYING |
CCI_U_TYPE_VARBIT |
CCI_A_TYPE_BIT |
T_CCI_BIT* |
NUMERIC |
CCI_U_TYPE_NUMERIC |
CCI_A_TYPE_STR |
char* |
INTERGER |
CCI_U_TYPE_INT |
CCI_A_TYPE_INT |
int* |
SAMLLINT |
CCI_U_TYPE_SHORT |
CCI_A_TYPE_INT |
int* |
MONETARY |
CCI_U_TYPE_MONETARY |
CCI_A_TYPE_DOUBLE |
double* |
FLOAT |
CCI_U_TYPE_FLOAT |
CCI_A_TYPE_FLOAT |
float* |
DOUBLE |
CCI_U_TYPE_DOUBLE |
CCI_A_TYPE_DOUBLE |
double* |
DATE |
CCI_U_TYPE_DATE |
CCI_A_TYPE_DATE |
T_CCI_DATE* |
TIME |
CCI_U_TYPE_TIME |
CCI_A_TYPE_DATE |
T_CCI_DATE* |
TIMESTAMP |
CCI_U_TYPE_TIMESTAMP |
CCI_A_TYPE_DATE |
T_CCI_DATE* |
SET |
CCI_U_TYPE_SET |
CCI_A_TYPE_SET |
T_CCI_SET |
MULTISET |
CCI_U_TYPE_MULTISET |
CCI_A_TYPE_SET |
T_CCI_SET |
SEQUENCE |
CCI_U_TYPE_SEQUENCE |
CCI_A_TYPE_SET |
T_CCI_SET |
OBJECT |
CCI_U_TYPE_OBJECT |
CCI_A_TYPE_STR |
char* |
|
STR |
BIT |
INT |
DOUBLE |
FLOAT |
DATE |
SET |
---|---|---|---|---|---|---|---|
STR |
O |
X |
O (1) |
O (1) |
O (1) |
O (2) |
X |
BIT |
O |
O |
X |
X |
X |
X |
X |
INT |
O (1) |
X |
O |
O |
O |
X |
X |
DOUBLE |
O (1) |
X |
O |
O |
O |
X |
X |
FLOAT |
O (1) |
X |
O |
O |
O |
X |
X |
DATE |
O (2) |
X |
X |
X |
X |
O |
X |
SET |
O (3) |
X |
X |
X |
X |
X |
O |
(1) : atoi, atof, atod
(2) : CUBRID type date : ‘YYYY/MM/DD’
CUBRID type time : ‘HH:MM:SS’
CUBRID type timestamp : ‘YYYY/MM/DD HH:MM:SS’