datatypes.md

June 19, 2019 ยท View on GitHub

TypeSqliteMySqlPostgresqlMs Sql server
boolBOOLEANBOOLEANBOOLEANBIT
QBitArrayBLOBVARBINARYBYTEAVARBINARY (MAX)
QByteArrayBLOBBLOBBYTEAVARBINARY (MAX)
QDateDATEDATEDATEDATE
QDateTimeDATETIMEDATETIMETIMESTAMPDATETIME
QTimeTIMETIMETIMETIME
doubleDOUBLEREALREALREAL
floatFLOATFLOATFLOATFLOAT(24)
signed charTINYINTTINYINTSMALLINTtinyint
charTINYINTCHAR(1)CHAR(1)CHAR(1)
ucharTINYINT UNSIGNEDTINYINTSMALLINTtinyint
shortSMALLINTSMALLINTSMALLINTsmallint
ushortSMALLINT UNSIGNEDSMALLINTSMALLINTsmallint
intINTINTINTEGERINT
uintINT UNSIGNEDINTINTEGERINT
longMEDIUMINTBIGINTBIGINTbigint
ulongMEDIUMINT UNSIGNEDBIGINTBIGINTbigint
qlonglongBIGINTBIGINTBIGINTbigint
qulonglongBIGINT UNSIGNEDBIGINTBIGINTbigint
QCharNCHAR(1)CHAR(1)CHAR(1)CHAR(1)
QUrlTEXTTEXTTEXTTEXT
QJsonArrayTEXTTEXTJSONBTEXT
QJsonValueTEXTTEXTJSONBTEXT
QJsonObjectTEXTTEXTJSONBTEXT
QJsonDocumentTEXTTEXTJSONBTEXT
QPointTEXTTEXTPOINTGEOMETRY
QPointFTEXTTEXTPOINTGEOMETRY
QSizeTEXTTEXTTEXTTEXT
QSizeFTEXTTEXTTEXTTEXT
QLineTEXTTEXTLINETEXT
QLineFTEXTTEXTLINETEXT
QRectTEXTTEXTBOXTEXT
QRectFTEXTTEXTBOXTEXT
QPolygonTEXTTEXTPOLYGONTEXT
QPolygonFTEXTTEXTPOLYGONTEXT
QStringListTEXTTEXTTEXT[]TEXT
QColorTEXTTEXTTEXTTEXT
QUuidTEXTTEXTUUIDUNIQUEIDENTIFIER
QStringTEXTTEXTTEXTNVARCHAR(MAX)