diff options
Diffstat (limited to 'src/sql/doc/src/qsqldatatype-table.qdoc')
-rw-r--r-- | src/sql/doc/src/qsqldatatype-table.qdoc | 219 |
1 files changed, 174 insertions, 45 deletions
diff --git a/src/sql/doc/src/qsqldatatype-table.qdoc b/src/sql/doc/src/qsqldatatype-table.qdoc index 1c5ab741c9..77aa56d21a 100644 --- a/src/sql/doc/src/qsqldatatype-table.qdoc +++ b/src/sql/doc/src/qsqldatatype-table.qdoc @@ -1,29 +1,5 @@ -/**************************************************************************** -** -** Copyright (C) 2016 The Qt Company Ltd. -** Contact: https://www.qt.io/licensing/ -** -** This file is part of the documentation of the Qt Toolkit. -** -** $QT_BEGIN_LICENSE:FDL$ -** Commercial License Usage -** Licensees holding valid commercial Qt licenses may use this file in -** accordance with the commercial license agreement provided with the -** Software or, alternatively, in accordance with the terms contained in -** a written agreement between you and The Qt Company. For licensing terms -** and conditions see https://www.qt.io/terms-conditions. For further -** information use the contact form at https://www.qt.io/contact-us. -** -** GNU Free Documentation License Usage -** Alternatively, this file may be used under the terms of the GNU Free -** Documentation License version 1.3 as published by the Free Software -** Foundation and appearing in the file included in the packaging of -** this file. Please review the following information to ensure -** the GNU Free Documentation License version 1.3 requirements -** will be met: https://www.gnu.org/licenses/fdl-1.3.html. -** $QT_END_LICENSE$ -** -****************************************************************************/ +// Copyright (C) 2016 The Qt Company Ltd. +// SPDX-License-Identifier: LicenseRef-Qt-Commercial OR GFDL-1.3-no-invariants-only /*! \page sql-types.html @@ -64,15 +40,15 @@ \row \li REAL \li 32-bit Single-precision floating point - \li By default mapping to QString + \li typedef qreal \row \li DOUBLE PRECISION \li 64-bit Double-precision floating point - \li By default mapping to QString + \li Mapped to QString for high precision doubles, otherwise qreal \row \li FLOAT \li 64-bit Double-precision floating point - \li By default mapping to QString + \li typedef qreal \row \li CHAR \li Fixed-length, null-terminated character string @@ -139,19 +115,19 @@ \row \li REAL FLOAT \li 32-bit floating point - \li By default mapping to QString + \li typedef qreal \row \li FLOAT \li 64-bit floating point - \li By default mapping to QString + \li typedef qreal \row \li DOUBLE \li 64-bit floating point - \li By default mapping to QString + \li typedef qreal \row \li DOUBLE PRECISION \li 64-bit Double-precision floating point - \li By default mapping to QString + \li Mapped to QString for high precision doubles, otherwise qreal \row \li VARCHAR STRING \li Character string, Unicode @@ -212,11 +188,11 @@ \row \li FLOAT \li 32-bit Floating Point - \li By default mapping to QString + \li typedef qreal \row \li DOUBLE \li 64-bit Floating Point - \li By default mapping to QString + \li Mapped to QString for high precision doubles, otherwise qreal \row \li CHAR \li Character string @@ -285,7 +261,7 @@ \row \li NUMBER \li FLOAT, DOUBLE, PRECISIONc REAL - \li By default mapping to QString + \li Mapped to QString for high precision doubles, otherwise qreal \row \li NUMBER(38) \li INTEGER INT SMALLINT @@ -293,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 @@ -353,15 +329,15 @@ \row \li REAL \li 32-bit Single-precision floating point - \li By default mapping to QString + \li typedef qreal \row \li FLOAT \li 64-bit Double floating point - \li By default mapping to QString + \li typedef qreal \row \li DOUBLE \li 64-bit Double floating point - \li By default mapping to QString + \li Mapped to QString for high precision doubles, otherwise qreal \row \li CHAR \li Character string @@ -418,19 +394,19 @@ \row \li REAL \li 32-bit variable-precision floating point - \li By default mapping to QString + \li typedef qreal \row \li DOUBLE PRECISION \li 64-bit variable-precision floating point - \li By default mapping to QString + \li Mapped to QString for high precision doubles, otherwise qreal \row \li DECIMAL VARIABLE \li user-specified precision, exact - \li Mapped to QString + \li typedef qreal \row \li NUMERIC VARIABLE \li user-specified precision, exact - \li Mapped to QString + \li typedef qreal \row \li VARCHAR \li variable-length character string @@ -488,7 +464,7 @@ \row \li REAL \li 64-bit floating point value. - \li By default mapping to QString + \li typedef qreal \row \li TEXT \li Character string (UTF-8, UTF-16BE or UTF-16-LE). @@ -502,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 */ |