|
|
|
Tables created with c-treeDB .NET are 100% compatible with FairCom DB SQL, even when tables are created without RECBYT or ROWID indexes. Tables created with c-treeDB .NET without transaction processing flags will not be able to participate in FairCom DB SQL transactions or transaction isolation levels.
Tables created by FairCom DB Plus applications must be 100% compatible with c-treeDB .NET to get the full benefit of all FairCom DB SQL commands and features. FairCom DB SQL makes extensive use of CTTable.AlterTable(), CTRecord.SetRecordOn(), and CTRecord.FindRecord(); any FairCom DB tables that do not support these operations, as described above, will have very little compatibility with FairCom DB SQL.
|
|
|
FairCom DB SQL Field Type |
c-treeDB/c-treeDB .NET Field Type |
|---|---|
BIT |
CT_BOOL |
TINYINT |
CT_TINYINT |
SMALLINT |
CT_SMALLINT |
INTEGER |
CT_INTEGER |
FLOAT |
CT_FLOAT |
DOUBLE |
CT_DOUBLE |
TID |
CT_UINTEGER |
CHAR |
CT_CHARS |
VARCHAR |
CT_VARCHAR |
LVARCHAR |
CT_LVARCHAR |
BINARY |
CT_BINARY |
VARBINARY |
CT_VARBINARY |
LVARBINARY |
CT_LVARBIN |
DATE |
CT_DATE |
TIME |
CT_TIME |
TIMESTAMP |
CT_TIMESTAMP |
BIGINT |
CT_BIGINT |
MONEY |
CT_CURRENCY |
NUMBER, NUMERIC, DECIMAL |
CT_NUMBER |
