NexusDB V3 Manual
Overview of Predefined Data Types
|
|
NexusDB Manual V3 > SQL Reference > SQL Data Types
|
Predefined data types in NexusDB SQL
SQL type
|
NexusDB type
|
Capacity
|
Conformance
|
CHARACTER [ ( length ) ]
|
nxtNullString
|
8192 characters
|
Core SQL
|
CHAR [ ( length ) ]
|
nxtNullString
|
8192 characters
|
Core SQL
|
NULLSTRING [ ( length ) ]
|
nxtNullString
|
8192 characters
|
NexusDB ext
|
SHORTSTRING [ ( length ) ]
|
nxtShortString
|
255 characters
|
NexusDB ext
|
SINGLECHAR
|
nxtChar
|
8-bit character
|
NexusDB ext
|
CHARACTER VARYING [ ( length ) ]
|
nxtNullString
|
8192 characters
|
Core SQL
|
CHAR VARYING [ (length) ]
|
nxtNullString
|
8192 characters
|
Core SQL
|
VARCHAR [ ( length ) ]
|
nxtNullString
|
8192 characters
|
Core SQL
|
|
|
|
|
CHARACTER LARGE OBJECT [ ( length ) ]
|
nxtBlobMemo
|
4GB
|
Feature T041
|
CHAR LARGE OBJECT [ ( length ) ]
|
nxtBlobMemo
|
4GB
|
Feature T041
|
CLOB [ ( length ) ]
|
nxtBlobMemo
|
4GB
|
Feature T041
|
TEXT [ ( length ) ]
|
nxtBlobMemo
|
4GB
|
NexusDB ext
|
|
|
|
|
NATIONAL CHARACTER [ ( length ) ]
|
nxtWideString
|
32767 characters
|
Feature F421
|
NATIONAL CHAR [ ( length ) ]
|
nxtWideString
|
32767 characters
|
Feature F421
|
NCHAR [ ( length ) ]
|
nxtWideString
|
32767 characters
|
Feature F421
|
NSINGLECHAR
|
nxtWideChar
|
16-bit character
|
NexusDB ext
|
NATIONAL CHARACTER VARYING [ ( length ) ]
|
nxtWideString
|
32767 characters
|
Feature F421
|
NATIONAL CHAR VARYING [ ( length ) ]
|
nxtWideString
|
32767 characters
|
Feature F421
|
NCHAR VARYING [ ( length ) ]
|
nxtWideString
|
32767 characters
|
Feature F421
|
NVARCHAR [ ( length ) ]
|
nxtWideString
|
32767 characters
|
NexusDB ext
|
|
|
|
|
NATIONAL CHARACTER LARGE OBJECT [ ( length ) ]
|
nxtBlobWideMemo
|
4GB
|
Feature T041
|
NCHAR LARGE OBJECT [ ( length ) ]
|
nxtBlobWideMemo
|
4GB
|
Feature T041
|
NCLOB [ ( length ) ]
|
nxtBlobWideMemo
|
4GB
|
Feature T041
|
|
|
|
|
BINARY LARGE OBJECT [ ( length ) ]
|
nxtBlob
|
4GB
|
Feature T041
|
BLOB [ ( length ) ]
|
nxtBlob
|
4GB
|
Feature T041
|
IMAGE [ ( length ) ]
|
nxtBlobGraphic
|
4GB
|
NexusDB ext
|
|
|
|
|
NUMERIC [ ( precision [ , scale ] ) ]
|
nxtBCD
|
Precision 20, scale 4
|
Core SQL
|
DECIMAL [ ( precision [ , scale ] ) ]
|
nxtBCD
|
Precision 20, scale 4
|
Core SQL
|
DEC [ ( precision [ , scale ] ) ]
|
nxtBCD
|
Precision 20, scale 4
|
Core SQL
|
BYTE
|
nxtByte
|
8-bit unsigned integer
|
NexusDB ext
|
TINYINT
|
nxtByte
|
8-bit unsigned integer
|
NexusDB ext
|
SHORTINT
|
nxtInt8
|
8-bit signed integer
|
NexusDB ext
|
SMALLINT
|
nxtInt16
|
16-bit signed integer
|
Core SQL
|
INTEGER
|
nxtInt32
|
32-bit signed integer
|
Core SQL
|
INT
|
nxtInt32
|
32-bit signed integer
|
Core SQL
|
AUTOINC [ ( start-value [ , increment-value ] ) ]
|
nxtAutoInc
|
32-bit unsigned integer
|
NexusDB ext
|
BIGINT
|
nxtInt64
|
64-bit signed integer
|
Feature T071
|
LARGEINT
|
nxtInt64
|
64-bit signed integer
|
NexusDB ext
|
WORD
|
nxtWord16
|
16-bit unsigned integer
|
NexusDB ext
|
DWORD
|
nxtWord32
|
32-bit unsigned integer
|
NexusDB ext
|
|
|
|
|
FLOAT [ ( precision ) ]
|
nxtSingle
|
1.5E-45 .. 3.4E38
|
Core SQL
|
REAL
|
nxtDouble
|
5.0E-324 .. 1.7E308
|
Core SQL
|
DOUBLE PRECISION
|
nxtDouble
|
5.0E-324 .. 1.7E308
|
Core SQL
|
EXTENDED
|
nxtExtended
|
3.6E-4951 .. 1.1E4932
|
NexusDB ext
|
MONEY
|
nxtCurrency
|
Precision 20, scale 4
|
NexusDB ext
|
|
|
|
|
BOOLEAN
|
nxtBoolean
|
8-bit boolean flag
|
Feature T031
|
BOOL
|
nxtBoolean
|
8-bit boolean flag
|
NexusDB ext
|
|
|
|
|
DATE
|
nxtDate
|
4 bytes
|
Core SQL
|
TIME
|
nxtTime
|
4 bytes
|
Core SQL
|
TIMESTAMP
|
nxtDateTime
|
8 bytes
|
Core SQL
|
DATETIME
|
nxtDateTime
|
8 bytes
|
NexusDB ext
|
|
|
|
|
GUID
|
nxtGuid
|
16 bytes
|
NexusDB ext
|
BYTEARRAY ( length )
|
nxtByteArray
|
64KB
|
NexusDB ext
|
RECREV
|
nxtRecRev
|
32-bit unsigned integer
|
NexusDB ext
|
|
© Nexus Database Systems Pty Ltd.