SQL Data Types

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

Data Types

Definition

Format

STRING(i.e., text, longtext, char)

UTF8 encoded string with Unicode support

‘text’

INTEGER

32-bit signed integer

one or more digits "0" to "9"

LONG

64-bit signed integer

large numeric/decimal value

FLOAT

32-bit floating point number

float(n)

DOUBLE

64-bit floating point number

decimal(p, s)

DATE

Date value

YYYY-MM-DD

INTERVAL

Encodes a span of time

year-month (YYYY-MM); day-time (DD HH:MM:SS)

TIMESTAMP

Time with microsecond precision.

YYYY-MM-DD [HH:MM:SS[.SSSSSS]]

BOOL

Boolean value

True or False



‍