FairCom DB API API for C# - Developers Guide

Field Types

FairCom DB API .NET supports all original c-tree Plus field types and includes redefinition for new field types. For compatibility reasons, the original c-tree Plus field types can be used, but FairCom suggests using the new FairCom DB API .NET field types.

Note that the "FairCom DB API .NET field types" do not represent new field types, but just a new name of the existing c-tree Plus field types. The new naming convention is used in the c-treeSQL product line, and offers a better description of the fields.

FairCom DB API .NET field types are defined in the enum type FIELD_TYPE that must be used every time a field type is needed (see above sample code).

FairCom DB API .NET Field Type	c-tree Plus Field Type	Equivalent Data Type	Implementation
BOOL	CT_BOOL	CTBOOL	One byte Boolean
TINYINT	CT_CHAR	CTSIGNED	Signed one byte integer
UTINYINT	CT_CHARU	CTUNSIGNED	Unsigned one byte integer
SMALLINT	CT_INT2	CTSIGNED	Signed two-byte integer
USMALLINT	CT_INT2U	CTUNSIGNED	Unsigned two-byte integer
INTEGER	CT_INT4	CTSIGNED	Signed four-byte integer
UINTEGER	CT_INT4U	CTUNSIGNED	Unsigned four-byte integer
MONEY	CT_MONEY	CTMONEY	Signed four-byte integer interpreted as number of pennies (two fixed decimal places) up to a precision of 9.
DATE	CT_DATE	CTDATE	Unsigned four-byte integer interpreted as date
TIME	CT_TIME	CTTIME	Unsigned four-byte integer interpreted as time
FLOAT	CT_SFLOAT	CTFLOAT	Four-byte floating point
DOUBL	CT_DFLOAT	CTFLOAT	Eight-byte floating point
TIMESTAMP	CT_TIMES	CTDATETIME	Time stamp
EFLOAT	CT_EFLOAT	CTFLOAT	Extended precision floating point (not supported as a key segment)
BINARY	CT_ARRAY	pTEXT, pUTEXT	Arbitrary fixed length data. Fixed length binary data
CHARS	CT_FSTRING	pTEXT	Fixed length delimited data. Fixed length string data
FPSTRING	CT_FPSTRING	pTEXT	Fixed length data with 1-byte length count
F2STRING	CT_F2STRING	pTEXT	Fixed length data with 2-byte length count
F4STRING	CT_F4STRING	pTEXT	Fixed length data with 4-byte length count
BIGINT	CT_BIGINT	CTBIGINT	Eight-byte signed integer
NUMBER	CT_NUMBER	CTNUMBER	Scaled BCD number
CURRENCY	CT_CURRENCY	CTCURRENCY	Eight-byte signed integer interpreted as currency value with four fixed decimal digits
VPSTRING	CT_PSTRING	pTEXT	Varying length field data with 1-byte length count
VARBINARY	CT_2STRING	pTEXT	Varying length field data with 2-byte length count. Variable length binary data of up to 65,535 bytes
LVB	CT_4STRING	pTEXT	Varying length field data with 4-byte length count. Variable length binary data of up to 4,294,967,295 bytes
VARCHAR or LVC	CT_STRING	pTEXT	Varying length field delimited data. Variable length string data