Accuracer: The First And Only BDE Alternative
Client-Server Single-File Embedded Database for Delphi / C++Builder / Kylix



Supported data types


Previous  Top  Next


Accuracer supports the following data types of fields in tables:

SQL data type
Description
Corresponding TFieldType
Char, FixedChar
Fixed character field
ftFixedChar
Varchar, Varchar2, String
Character or variable length string field
ftString
WideChar, FixedWideChar
Fixed wide character field
ftWideString
WideVarchar, WideString
Wide character or variable length wide string field
ftWideString
Shortint, SignedInt8
8-bit integer field
ftSmallint
Smallint, SignedInt16
16-bit integer field
ftSmallint
Integer, SignedInt32
32-bit integer field
ftInteger
Largeint, Int64, SignedInt64
64-bit integer field
ftLargeint
Byte, UnsignedInt8
Byte field
ftWord
Word, UnsignedInt16
16-bit unsigned integer field
ftWord
Cardinal, UnsignedInt32
32-bit unsigned integer field
ftLargeint
AutoInc, AutoIncInteger
Auto-incrementing 32-bit integer counter field
ftAutoinc
AutoIncShortint
Auto-incrementing 8-bit integer counter field
ftAutoinc
AutoIncSmallint
Auto-incrementing 16-bit integer counter field
ftAutoinc
AutoIncLargeint
Auto-incrementing 64-bit integer counter field
ftAutoinc
AutoIncByte
Auto-incrementing byte counter field
ftAutoinc
AutoIncWord
Auto-incrementing 16-bit unsigned integer counter field

ftAutoinc
AutoIncCardinal
Auto-incrementing 32-bit unsigned integer counter field
ftAutoinc
Single
Single floating-point numeric field
ftFloat
Float, Double
Double floating-point numeric field
ftFloat

Extended
Extended floating-point numeric field
ftFloat

Boolean, Logical, Bool, Bit
Boolean field
ftBoolean
Currency, Money
Money field
ftCurrency
Date
Date field
ftDate
Time
Time field
ftTime
DateTime
Date and time field
ftDateTime
TimeStamp
Date and time field accessed through dbExpress
ftTimeStamp
Bytes
Fixed number of bytes (binary storage)
ftBytes
VarBytes
Variable number of bytes (binary storage)
ftVarBytes
Blob
Binary Large OBject field
ftBlob
Graphic
Bitmap field
ftGraphic
Memo, Clob
Text memo field
ftMemo
FormattedMemo, FmtMemo
Formatted text memo field
ftFmtMemo
WideMemo, WideClob
Unicode text memo field
ftMemo





© AidAim Software Accuracer: Client-server Database Single-file Database Delphi Database Embedded Databas