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) |
STRING | UTF8 encoded string with Unicode support | |
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}} |

