A QtSql driver for Mimer SQL

The QtSql for Mimer SQL sqldriver makes it possible to work with the
Mimer SQL database on different plattforms. There are drivers for
several other databases in QtSql and a driver for Mimer SQL will
benefit many users.
To build the Mimer SQL driver, download Mimer SQL from
https://developer.mimer.com

[ChangeLog][QtSql]
Added a QtSql plugin to work with the Mimer SQL database

Fixes: QTBUG-111219
Change-Id: Id6ba5de4de01189d0516ffbfa89efcb0d013115f
Reviewed-by: Qt CI Bot <qt_ci_bot@qt-project.org>
Reviewed-by: Volker Hilsheimer <volker.hilsheimer@qt.io>

2 files changed, 129 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
 */
diff --git a/src/sql/doc/src/sql-driver.qdoc b/src/sql/doc/src/sql-driver.qdoc
index 63ee513fa5..b2e3f6c225 100644
--- a/src/sql/doc/src/sql-driver.qdoc
+++ b/src/sql/doc/src/sql-driver.qdoc
@@ -30,6 +30,7 @@
             ODBC-compliant databases
     \row \li \l{#QPSQL}{QPSQL} \li PostgreSQL (versions 7.3 and above)
     \row \li \l{#QSQLITE}{QSQLITE} \li SQLite version 3
+    \row \li \l{#QMIMER}{QMIMER} \li Mimer SQL (version 11 and above)
     \endtable
 
     SQLite is the in-process database system with the best test coverage
@@ -791,6 +792,47 @@
     Some versions of SQLite can be forced to write a specific file format by setting
     the \c{SQLITE_DEFAULT_FILE_FORMAT} define when building SQLite.
 
+    \target QMIMER
+    \section2 QMIMER for Mimer SQL version 11 and higher
+
+    The Qt Mimer SQL plugin makes it possible to work with the Mimer SQL RDBMS.
+    Mimer SQL provides small footprint, scalable and robust relational database
+    solutions that conform to international ISO SQL standards. Mimer SQL is available
+    on Windows, Linux, \macos, and OpenVMS as well as several embedded platforms like QNX, Android,
+    and embedded Linux.
+
+    Mimer SQL fully support Unicode. To work with Unicode data the column types National Character (NCHAR),
+    National Character Varying (NVARCHAR), or National Character Large Object (NCLOB) must be used.
+    For more information about Mimer SQL and unicode, see \l{https://developer.mimer.com/features/multilingual-support}
+
+    \section3 QMIMER Stored Procedure Support
+
+    Mimer SQL have stored procedures according to the SQL standard (PSM) and
+    the plugin fully support IN, OUT, INOUT parameters as well as resultset procedures.
+
+    Example stored procedure with INOUT and OUT parameters:
+
+    \snippet code/doc_src_sql-driver.qdoc 44
+
+    Source code to access the INOUT and OUT values:
+
+    \snippet code/doc_src_sql-driver.cpp 40
+
+    \section3 How to Build the QMIMER Plugin on Unix and \macos
+
+    You need the Mimer SQL header files and shared libraries. Get them by installing
+    any of the Mimer SQL variants found at \l{https://developer.mimer.com}.
+
+
+    \snippet code/doc_src_sql-driver.qdoc 31
+
+    \section3 How to Build the QMIMER Plugin on Windows
+
+    You need the Mimer SQL header files and shared libraries. Get them by installing
+    any of the Mimer SQL variants found at \l{https://developer.mimer.com}.
+
+    \snippet code/doc_src_sql-driver.qdoc 32
+
     \target QIBASE
     \section2 QIBASE for Borland InterBase