데이터베이스 타입

CAS 데이터 타입

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 data type의 내부 표현

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*

bind_param, get_data 타입 변환

 

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’