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) |