Skip to content

Supported datatypes

Hamed Masafi edited this page Dec 21, 2019 · 1 revision
Type Sqlite MySql Postgresql Ms Sql server
bool BOOLEAN BOOLEAN BOOLEAN BIT
QBitArray BLOB VARBINARY BYTEA VARBINARY (MAX)
QByteArray BLOB BLOB BYTEA VARBINARY (MAX)
QDate DATE DATE DATE DATE
QDateTime DATETIME DATETIME TIMESTAMP DATETIME
QTime TIME TIME TIME TIME
double DOUBLE REAL REAL REAL
float FLOAT FLOAT FLOAT FLOAT(24)
signed char TINYINT TINYINT SMALLINT tinyint
char TINYINT CHAR(1) CHAR(1) CHAR(1)
uchar TINYINT UNSIGNED TINYINT SMALLINT tinyint
short SMALLINT SMALLINT SMALLINT smallint
ushort SMALLINT UNSIGNED SMALLINT SMALLINT smallint
int INT INT INTEGER INT
uint INT UNSIGNED INT INTEGER INT
long MEDIUMINT BIGINT BIGINT bigint
ulong MEDIUMINT UNSIGNED BIGINT BIGINT bigint
qlonglong BIGINT BIGINT BIGINT bigint
qulonglong BIGINT UNSIGNED BIGINT BIGINT bigint
QChar NCHAR(1) CHAR(1) CHAR(1) CHAR(1)
QUrl TEXT TEXT TEXT TEXT
QJsonArray TEXT TEXT JSONB TEXT
QJsonValue TEXT TEXT JSONB TEXT
QJsonObject TEXT TEXT JSONB TEXT
QJsonDocument TEXT TEXT JSONB TEXT
QPoint TEXT TEXT POINT GEOMETRY
QPointF TEXT TEXT POINT GEOMETRY
QSize TEXT TEXT TEXT TEXT
QSizeF TEXT TEXT TEXT TEXT
QLine TEXT TEXT LINE TEXT
QLineF TEXT TEXT LINE TEXT
QRect TEXT TEXT BOX TEXT
QRectF TEXT TEXT BOX TEXT
QPolygon TEXT TEXT POLYGON TEXT
QPolygonF TEXT TEXT POLYGON TEXT
QStringList TEXT TEXT TEXT[] TEXT
QColor TEXT TEXT TEXT TEXT
QUuid TEXT TEXT UUID UNIQUEIDENTIFIER
QString TEXT TEXT TEXT NVARCHAR(MAX)

Table of contents

Clone this wiki locally