FourQ Data Types

FourQ Data Types

FourQ uses a series of generic data-types internally that map to specific column data-types depending on the database in question.

Very much a work in progress...

data type

mysql

mssql

postgresql

oracle

Notes

data type

mysql

mssql

postgresql

oracle

Notes

boolean

tinyint(1)

date

datetime

numeric

decimal(10,2)

string

varchar(255)

nstring

varchar(255)

uuid

varchar(50)

variablename

varchar(64)

color

varchar(20)

email

varchar(255)

longchar

longtext