42 lines
1.9 KiB
Markdown
42 lines
1.9 KiB
Markdown
|
| 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) |
|