While creating a table, you need to specify a data type for each column to define what kind of data you want to store. This section will look into the various data types supported in Oxla. Now, let’s get an overview of each data type:

Data TypesDefinitionFormat
BOOLBoolean value.True or False.
TEXTUTF8 encoded string with Unicode support.‘text’
TIMESTAMP WITHOUT TIME ZONETime and date values without a time zone.YYYY-MM-DD [HH:MM:SS[.SSSSSS]]
TIMESTAMP WITH TIME ZONEDate and time values, including the time zone information.YYYY-MM-DD HH:MM:SS.SSSSSS+TZ
TIMETime values without any date information.HH:MM:SS[.SSSSSS]
JSONA value in JSON standard format.variable_name JSON
INTERVALEncodes a span of timeyear-month (YYYY-MM); day-time (DD HH:MM:SS)
INT32-bit signed integerone or more digits “0” to “9”
BIGINT64-bit signed integerlarge numeric/decimal value
REAL32-bit floating point numberfloat(n)
DOUBLE PRECISION64-bit floating point numberdecimal(p, s)