summaryrefslogtreecommitdiffstats
path: root/src/sql/doc/src/qsqldatatype-table.qdoc
diff options
context:
space:
mode:
Diffstat (limited to 'src/sql/doc/src/qsqldatatype-table.qdoc')
-rw-r--r--src/sql/doc/src/qsqldatatype-table.qdoc88
1 files changed, 87 insertions, 1 deletions
diff --git a/src/sql/doc/src/qsqldatatype-table.qdoc b/src/sql/doc/src/qsqldatatype-table.qdoc
index 58a27a05a4..6eabf269c8 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,90 @@
\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 BIGINT
+ \li 64-bit signed integer
+ \li typedef qint64
+ \row
+ \li REAL
+ \li 32-bit Single-precision floating point
+ \li typedef qreal
+ \row
+ \li DOUBLE PRECISION
+ \li 64-bit Double-precision floating point
+ \li Mapped to QString for high precision doubles, otherwise qreal
+ \row
+ \li FLOAT
+ \li 64-bit Double-precision floating point
+ \li typedef qreal
+ \row
+ \li CHAR
+ \li Fixed-length, null-terminated character string
+ \li Mapped to QString
+ \row
+ \li VARCHAR
+ \li Null-terminated varying length string
+ \li Mapped to QString
+ \row
+ \li NCHAR
+ \li Fixed-length, null-terminated Unicode character string
+ \li Mapped to QString
+ \row
+ \li NVARCHAR
+ \li Null-terminated varying length Unicode string
+ \li Mapped to QString
+ \row
+ \li BLOB
+ \li Not null-terminated varying binary string with 4-byte string
+ length indicator
+ \li Mapped to QByteArray
+ \row
+ \li CLOB
+ \li Character large string object
+ \li Mapped to QString
+ \row
+ \li NCLOB
+ \li National Character large string object
+ \li Mapped to QString
+ \row
+ \li DATE
+ \li Null-terminated character string of the following format:
+ yyyy-mm-dd
+ \li Mapped to QDate
+ \row
+ \li TIME
+ \li Null-terminated character string of the following format: hh.mm.ss
+ \li Mapped to QTime
+ \row
+ \li TIMESTAMP
+ \li Null-terminated character string of the following format: yyyy-mm-dd-hh.mm.ss.nnnnnn
+ \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 DECIMAL(p,s)
+ \li By default mapping to QString
+ \endtable
*/