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
|
|