diff options
Diffstat (limited to 'src/sql/doc/src/qsqldatatype-table.qdoc')
-rw-r--r-- | src/sql/doc/src/qsqldatatype-table.qdoc | 155 |
1 files changed, 154 insertions, 1 deletions
diff --git a/src/sql/doc/src/qsqldatatype-table.qdoc b/src/sql/doc/src/qsqldatatype-table.qdoc index 58a27a05a4..77aa56d21a 100644 --- a/src/sql/doc/src/qsqldatatype-table.qdoc +++ b/src/sql/doc/src/qsqldatatype-table.qdoc @@ -269,7 +269,7 @@ \row \li NUMBER(p,s) \li NUMERIC(p,s) DECIMAL(p,s)a - \li By default mapping to QString + \li Mapped to QString \row \li NVARCHAR2(n) \li Character string (NATIONAL CHARACTER VARYING(n) NATIONAL @@ -478,4 +478,157 @@ \li The value is a BLOB of data, stored exactly as it was input. \li Mapped to QByteArray \endtable + + \section2 Mimer SQL Data Types + + \table 90% + \header + \li Mimer SQL type + \li SQL type description + \li Recommended input (C++ or Qt data type) + \row + \li SMALLINT + \li 16-bit signed integer + \li typedef qint16 + \row + \li INTEGER + \li 32-bit signed integer + \li typedef qint32 + \row + \li INTEGER(n) + \li Integer with up to 45 digits precision + \li Mapped to QString + \row + \li BIGINT + \li 64-bit signed integer + \li typedef qint64 + \row + \li REAL + \li 32-bit Single-precision IEEE floating point + \li typedef float + \row + \li DOUBLE PRECISION + \li 64-bit Double-precision IEEE floating point + \li Mapped to QString for high precision doubles, otherwise qreal + \row + \li FLOAT + \li 64-bit Double-precision IEEE floating point + \li Mapped to QString for high precision doubles, otherwise qreal + \row + \li FLOAT(n) + \li Floating point with up to 45 digits precision + \li Mapped to QString + \row + \li DECIMAL(p,s) + \li Decimal with up to 45 digits precision and scale + \li Mapped to QString + \row + \li CHAR + \li Fixed-length character Latin-1 string (CHAR or character) + \li Mapped to QString + \row + \li VARCHAR + \li Variable length Latin-1 string (VARCHAR or CHARACTER VARYING) + \li Mapped to QString + \row + \li NCHAR + \li Fixed-length Unicode string (NCHAR or NATIONAL CHARACTER) + \li Mapped to QString + \row + \li NVARCHAR + \li Variable length Unicode string (NVARCHAR or NATIONAL CHARACTER VARYING) + \li Mapped to QString + \row + \li BINARY + \li Fixed length binary data + \li Mapped to QByteArray + \row + \li VARBINARY + \li Variable length binary data (VARBINARY or BINARY VARYING) + \li Mapped to QByteArray + \row + \li BLOB + \li Binary large object (BLOB or BINARY LARGE OBJECT) + \li Mapped to QByteArray + \row + \li CLOB + \li Latin-1 character large object (CLOB or CHARACTER LARGE OBJECT) + \li Mapped to QString + \row + \li NCLOB + \li Unicode character large object (NCLOB or NATIONAL CHARACTER LARGE OBJECT) + \li Mapped to QString + \row + \li DATE + \li Date consisting of year, month, and day + \li Mapped to QDate + \row + \li TIME + \li Time consisting of hours, minute, seconds with optional fractional seconds + \li Mapped to QTime + \row + \li TIMESTAMP + \li Date and time with optional fractional seconds + \li Mapped to QDateTime + \row + \li BUILTIN.UUID + \li Universally unique identifier + \li Mapped to QUuid + \row + \li BOOLEAN + \li Boolean + \li bool + \row + \li INTERVAL YEAR(7) + \li Year, format '±yyyyyyy' (max precision) + \li Mapped to QString + \row + \li INTERVAL YEAR(7) TO MONTH + \li Year to month, format '±yyyyyyy-mm' (max precision) + \li Mapped to QString + \row + \li INTERVAL MONTH(7) + \li Month, format '±mmmmmmm' (max precision) + \li Mapped to QString + \row + \li INTERVAL DAY(7) + \li Day, format '±ddddddd' (max precision) + \li Mapped to QString + \row + \li INTERVAL DAY(7) TO HOUR + \li Day to hour, format '±ddddddd hh' (max precision) + \li Mapped to QString + \row + \li INTERVAL DAY(7) TO MINUTE + \li Day to minute, format '±ddddddd hh:mm' (max precision) + \li Mapped to QString + \row + \li INTERVAL DAY(7) TO SECOND(9) + \li Day to second, format '±ddddddd hh:mm:ss[.fffffffff]' (max precision) + \li Mapped to QString + \row + \li INTERVAL HOUR(8) + \li Hour, format '±hhhhhhhh' (max precision) + \li Mapped to QString + \row + \li INTERVAL HOUR(8) TO MINUTE + \li Hour to minute, format '±hhhhhhhh:mm' (max precision) + \li Mapped to QString + \row + \li INTERVAL HOUR(8) TO SECOND(9) + \li Hour to second, format '±hhhhhhhh:mm:ss[.fffffffff]' (max precision) + \li Mapped to QString + \row + \li INTERVAL MINUTE(10) + \li Minute, format '±mmmmmmmmmm' (max precision) + \li Mapped to QString + \row + \li INTERVAL MINUTE(10) TO SECOND(9) + \li Minute to second, format '±mmmmmmmmmm:ss[.fffffffff]' (max precision) + \li Mapped to QString + \row + \li INTERVAL SECOND(12,9) + \li Second, format '±ssssssssssss[.fffffffff]' (max precision) + \li Mapped to QString + \endtable */ |