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

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