|
SQL type
|
DBMS type
|
|
BIT
|
EDbColBit
|
|
TINYINT
|
EDbColInt8
|
|
UNSIGNED
TINYINT
|
EDbColUint8
|
|
SMALLINT
|
EDbColInt16
|
|
UNSIGNED
SMALLINT
|
EDbColUint16
|
|
INTEGER
|
EDbColInt32
|
|
UNSIGNED
INTEGER
|
EDbColUint32
|
|
COUNTER
|
EDbColUint32, with the TDbCol::EAutoIncrement attribute
|
|
BIGINT
|
EDbColInt64
|
|
REAL
|
EDbColReal32
|
|
FLOAT
|
EDbColReal64
|
|
DOUBLE
|
EDbColReal64
|
|
DOUBLE PRECISION
|
EDbColReal64
|
|
DATE
|
EDbColDateTime
|
|
TIME
|
EDbColDateTime
|
|
TIMESTAMP
|
EDbColDateTime
|
|
CHAR(n)
|
EDbColText, where n specifies a maximum column length
|
|
VARCHAR(n)
|
EDbColText, where n specifies a maximum column length
|
|
LONG VARCHAR
|
EDbColLongText
|
|
BINARY(n)
|
EDbColBinary, where n specifies a maximum column length
|
|
VARBINARY(n)
|
EDbColBinary, where n specifies a maximum column length
|
|
LONG VARBINARY
|
EDbColLongBinary
|
|
DECIMAL(p,s)
|
Not supported
|
|
NUMERIC(p,s)
|
Not supported
|
|
![[Index]](../../../../../../a_stock/btn_index_wt.gif){kind=small}
![[Spacer]](../../../../../../a_stock/btn_spacer.gif){kind=small}
![[Previous]](../../../../../../a_stock/btn_prev_wt.gif){kind=small}
![[Next]](../../../../../../a_stock/btn_next_wt.gif){kind=small}
![[Previous]](../../../../../../a_stock/btn_prev.gif){kind=small}
![[Top]](../../../../../../a_stock/btn_top.gif)
![[Next]](../../../../../../a_stock/btn_next.gif){kind=small}