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

BCD [ ( precision [ , scale ] ) ]

nxtBCD

Precision 20, scale 4

 

FMTBCD [ ( precision [ , scale ] ) ]

nxtFmtBCD

Precision 20, scale 4

 

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