SQL Data Types

1min

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)
﻿STRING﻿
UTF8 encoded string with Unicode support
﻿
﻿TIMESTAMP﻿
Time with microsecond precision.
YYYY-MM-DD [HH:MM:SS[.SSSSSS]]
Time with microsecond precision.
YYYY-MM-DD [HH:MM:SS[.SSSSSS]]
﻿BOOL 
Boolean value
True or False
﻿JSON﻿
JSON data type
{"customer":"Dean Smith", "items":{"product:"cup","qty":2}} 
﻿

Updated 11 May 2023

Did this page help you?

Yes

OFFSET

Data Type Operators

Docs powered by archbee

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)
STRING	UTF8 encoded string with Unicode support
TIMESTAMP Time with microsecond precision. YYYY-MM-DD [HH:MM:SS[.SSSSSS]]	Time with microsecond precision.	YYYY-MM-DD [HH:MM:SS[.SSSSSS]]
BOOL	Boolean value	True or False
JSON	JSON data type	{"customer":"Dean Smith", "items":{"product:"cup","qty":2}}