Schema data types

Thibaut Rey edited this page Jun 8, 2015 · 16 revisions

Back to Overview

Relational databases

Caminte
Typenames
Cast in adapters
mysql postgres sqlite3 firebird
Number INTEGER INTEGER INTEGER INTEGER
Integer INTEGER INTEGER INTEGER INTEGER
Float FLOAT DOUBLE PRECISION REAL REAL
Double FLOAT DOUBLE PRECISION REAL REAL
Real REAL REAL REAL REAL
Boolean TINYINT BOOLEAN BOOLEAN BOOLEAN
Date DATETIME TIMESTAMP DATETIME DATETIME
String VARCHAR VARCHAR VARCHAR VARCHAR
Text TEXT TEXT TEXT TEXT
Json TEXT JSON TEXT TEXT
BLOB
no datatype specified
NONE NONE NONE NONE