Nexus supports the following field types:
Type |
Capacity |
AutoInc |
32 bit unsigned integer |
BCD |
Precision 20, scale 4 |
BLOB |
4 GB |
BLOB Graphic |
4 GB |
BLOB Memo |
4 GB |
Boolean |
8 bit boolean flag |
Byte |
8 bit unsigned integer |
Byte Array |
64 KB |
Char |
8 bit character |
Currency |
Precision 20, scale 4 |
Date |
4 bytes |
DateTime |
8 bytes |
Double |
5.0E-324 .. 1.7E308 |
Extended |
3.6E-4951 .. 1.1E4932 |
GUID |
16 bytes |
Int8 |
8 bit signed integer |
Int16 |
16 bit signed integer |
Int32 |
32 bit signed integer |
Int64 |
64 bit signed integer |
NullString |
8192 characters |
RevRev |
32 bit unsigned integer |
ShortString |
255 |
Single |
1.5E-45 .. 3.4E38 |
Time |
4 bytes |
WideChar |
16 bit character |
WideString |
32767 characters |
Word16 |
16 bit unsigned integer |
Word32 |
32 bit unsigned integer |