|
|
|
c-tree DODA Type |
Default SQL Type Mapping |
CT_BOOL |
BIT |
CT_CHAR |
TINYINT |
CT_CHARU |
TINYINT or SMALLINT (w/ promotion option) |
CT_INT2 |
SMALLINT |
CT_INT2U |
SMALLINT or INTEGER (w/ promotion option) |
CT_INT4 |
INTEGER |
CT_INT4U |
INTEGER or BIGINT (w/ promotion option) |
CT_MONEY CT_CURRENCY |
MONEY |
CT_DATE |
DATE |
CT_TIME |
TIME |
TIMES |
TIMESTAMP |
CT_SFLOAT |
REAL |
CT_DFLOAT CT_EFLOAT |
DOUBLE |
CT_SQLBCD |
NUMERIC |
CT_FSTRING CT_FPSTRING CT_F4STRING |
if ( length <= maxlen && length != 0 ) CHAR else LVARCHAR |
CT_STRING CT_PSTRING |
if ( length <= maxlen && length != 0 ) if ( isvlen ) VARCHAR else CHAR else LVARCHAR |
CT_F2STRING CT_ARRAY |
if ( length <= maxlen ) BINARY else LVARBINARY |
CT_2STRING |
if (length <= maxlen && length != 0 ) (binflag == CTDB_BINARY_VARCHAR) ? VARCHAR : VARBINARY else LVARBINARY |
CT_4STRING |
switch( binflag ) case CTDB_BINARY_VARCHAR LVARCHAR case CTDB_BINARY_CLOB CLOB case CTDB_BINARY_BLOB BLOB default: LVARBINARY |
CT_INT8 |
BIGINT |
CT_INT8U |
BIGINT or NUMERIC (20) (w/ promotion option) |
CT_FUNICODE CT_F2UNICODE |
NCHAR |
CT_UNICODE CT_2UNICODE |
NVARCHAR |
CT_UNIXTIME_T |
A 4 byte UNIX timestamp that maps to the SQL TIMESTAMP type |
CT_UNIXTIME64_T |
An 8 byte UNIX timestamp that maps to the SQL TIMESTAMP type |
* In V11.5, maxlen is currently 8192.
