Data Types

Supported data types of data table columns.

Each column of a table has to have assigned data type. The qikkDB supports boolean, numeric types, strings, date type and geometry types.

Data Type

Size

Description

Bool

1 byte

Representing TRUE or FALSE values

Int

4 bytes

Representing integer in range

-2,147,483,648 to 2,147,483,647

Long

8 bytes

Representing integer in range

-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807

Float

4 bytes

Representing floating-point numbers (precision 7 digits)

Double

8 bytes

Representing floating-point numbers (precision 15 digits)

Geo_Point

8 bytes

Representing geometry point with x and y

Geo_Polygon

Representing polygon as a series of points with x and y. It can contain also complex polygons that are composed of multiple polygons.

String

Representing text values with unlimited length

Date

8 bytes

Representing date and time. Format: year-month-day hour:minute:second