Data Types

Supported data types of data table columns.

Since version: 1.4 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

Column Type Code

Size

Description

Bool

15

1 byte

Representing TRUE or FALSE values

Int

8

4 bytes

Representing integer in range

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

Long

9

8 bytes

Representing integer in range

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

Float

10

4 bytes

Representing floating-point numbers (precision 7 digits)

Double

11

8 bytes

Representing floating-point numbers (precision 15 digits)

Geo_Point

12

8 bytes

Representing geometry point with latitude (Float - 4 bytes) and longitude (Float - 4 bytes)

Geo_Polygon

13

variable

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

String

14

variable

Representing text values with length up to 2,147,483,647 characters

Date

9

8 bytes

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