NexusDB V3 Manual
Field Types
|
|
NexusDB Manual V3 > Management Tools > The Enterprise Manager > Creating and Restructuring Tables
|
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
|
|
© Nexus Database Systems Pty Ltd.