diff options
author | Casper van Donderen <casper.vandonderen@nokia.com> | 2012-04-27 15:18:27 +0200 |
---|---|---|
committer | Qt by Nokia <qt-info@nokia.com> | 2012-04-28 13:53:46 +0200 |
commit | 00b961c37f82977615ab9c4d03e185229cc55154 (patch) | |
tree | bc9012d3ac08c19f2a66b5733dd8450506742243 /doc/src/sql/sql-programming/qsqldatatype-table.qdoc | |
parent | 82fa92b23cca834481571f0b0a5d66bc33a672e9 (diff) |
Doc: Fix most qdoc errors in QtSql.
- Move 2 images from qtdoc.
- Add "make docs" command for qtsql
- Fix qdoc command usage errors.
Change-Id: Id2f0548d09ed8f77b2317863d443c19d1cccdd83
Reviewed-by: Lars Knoll <lars.knoll@nokia.com>
Diffstat (limited to 'doc/src/sql/sql-programming/qsqldatatype-table.qdoc')
-rw-r--r-- | doc/src/sql/sql-programming/qsqldatatype-table.qdoc | 570 |
1 files changed, 0 insertions, 570 deletions
diff --git a/doc/src/sql/sql-programming/qsqldatatype-table.qdoc b/doc/src/sql/sql-programming/qsqldatatype-table.qdoc deleted file mode 100644 index a7e03cf28f..0000000000 --- a/doc/src/sql/sql-programming/qsqldatatype-table.qdoc +++ /dev/null @@ -1,570 +0,0 @@ -/**************************************************************************** -** -** Copyright (C) 2012 Nokia Corporation and/or its subsidiary(-ies). -** Contact: http://www.qt-project.org/ -** -** This file is part of the documentation of the Qt Toolkit. -** -** $QT_BEGIN_LICENSE:FDL$ -** GNU Free Documentation License -** 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. -** -** Other Usage -** Alternatively, this file may be used in accordance with the terms -** and conditions contained in a signed written agreement between you -** and Nokia. -** -** -** -** -** -** $QT_END_LICENSE$ -** -****************************************************************************/ - -/*! - \page sql-types.html - \title Data Types for Qt-supported Database Systems - \brief Recommended data types for database systems - - \ingroup qt-sql - - \section1 Recommended Data Types for Qt-Supported Database Systems - - This table shows the recommended data types for extracting data from - the databases supported in Qt. Note that types used in Qt are not - necessarily valid as input types to a specific database - system. e.g., A double might work perfectly as input for floating - point records in a particular database, but not necessarily as a - storage format for output from that database, because it would be - stored with 64-bit precision in C++. - - \tableofcontents - - \section2 IBM DB2 Data Types - - \table 90% - \header - \li IBM DB2 data 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 By default mapping to QString - \row - \li DOUBLE PRECISION - \li 64-bit Double-precision floating point - \li By default mapping to QString - \row - \li FLOAT - \li 64-bit Double-precision floating point - \li By default mapping to QString - \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 LONG VARCHAR - \li Not null-terminated varying length character 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 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 - \endtable - - \section2 Borland InterBase Data Types - - \table 90% - \header - \li Borland InterBase data type - \li SQL type description - \li Recommended input (C++ or Qt data type) - \row - \li BOOLEAN - \li Boolean - \li bool - \row - \li TINYINT - \li 8 bit signed integer - \li typedef qint8 - \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 LONG - \li 64-bit signed integer - \li typedef qint64 - \row - \li REAL FLOAT - \li 32-bit floating point - \li By default mapping to QString - \row - \li FLOAT - \li 64-bit floating point - \li By default mapping to QString - \row - \li DOUBLE - \li 64-bit floating point - \li By default mapping to QString - \row - \li DOUBLE PRECISION - \li 64-bit Double-precision floating point - \li By default mapping to QString - \row - \li VARCHAR STRING - \li Character string, Unicode - \li Mapped to QString - \row - \li CLOB - \li Character large string object - \li Mapped to QString - \row - \li DATE - \li Displays date. Format: 'yyyy-mm-dd' - \li Mapped to QDate - \row - \li TIME - \li Displays time. Format is 'hh:mm:ss' in 24-hour format - \li Mapped to QTime - \row - \li TIMESTAMP - \li Displays a timestamp. Format is 'yyyy-mm-dd hh:mm:ss' - \li Mapped to QDateTime - \endtable - - \section2 MySQL Data Types - - \table 90% - \header - \li MySQL data type - \li SQL type description - \li Recommended input (C++ or Qt data type) - \row - \li TINYINT - \li 8 bit signed integer - \li typedef qint8 - \row - \li TINYINT UNSIGNED - \li 8 bit unsigned integer - \li typedef quint8 - \row - \li SMALLINT - \li 16-bit signed integer - \li typedef qint16 - \row - \li SMALLINT UNSIGNED - \li 16-bit unsigned integer - \li typedef quint16 - \row - \li INT - \li 32-bit signed integer - \li typedef qint32 - \row - \li INT UNSIGNED - \li 32-bit unsigned integer - \li typedef quint32 - \row - \li BIGINT - \li 64-bit signed integer - \li typedef qint64 - \row - \li FLOAT - \li 32-bit Floating Point - \li By default mapping to QString - \row - \li DOUBLE - \li 64-bit Floating Point - \li By default mapping to QString - \row - \li CHAR - \li Character string - \li Mapped to QString - \row - \li VARCHAR - \li Character string - \li Mapped to QString - \row - \li TINYTEXT - \li Character string - \li Mapped to QString - \row - \li TEXT - \li Character string - \li Mapped to QString - \row - \li MEDIUMTEXT - \li Character string - \li Mapped to QString - \row - \li LONGTEXT - \li Character string - \li Mapped to QString - \row - \li CLOB - \li Character large string object - \li Mapped to QString - \row - \li all BLOB types - \li BLOB - \li Mapped to QByteArray - \row - \li DATE - \li Date without Time - \li Mapped to QDate - \row - \li DATETIME - \li Date and Time - \li Mapped to QDateTime - \row - \li TIMESTAMP - \li Date and Time - \li Mapped to QDateTime - \row - \li TIME - \li Time - \li Mapped to QTime - \row - \li YEAR - \li Year (int) - \li Mapped to QDateTime - \row - \li ENUM - \li Enumeration of Value Set - \li Mapped to QString - \endtable - - \section2 Oracle Call Interface Data Types - - \table 90% - \header - \li Oracle Call Interface data type - \li SQL type description - \li Recommended input (C++ or Qt data type) - \row - \li NUMBER - \li FLOAT, DOUBLE, PRECISIONc REAL - \li By default mapping to QString - \row - \li NUMBER(38) - \li INTEGER INT SMALLINT - \li typedef qint8/16/32/64 - \row - \li NUMBER(p,s) - \li NUMERIC(p,s) DECIMAL(p,s)a - \li By default mapping to QString - \row - \li NVARCHAR2(n) - \li Character string (NATIONAL CHARACTER VARYING(n) NATIONAL - CHAR VARYING(n) NCHAR VARYING(n)) - \li Mapped to QString - \row - \li NCHAR(n) - \li Character string (NATIONAL CHARACTER(n) NATIONAL CHAR(n) - NCHAR(n)) - \li Mapped to QString - \row - \li CHAR(n) - \li Character string (CHARACTER(n) CHAR(n)) - \li Mapped to QString - \row - \li CLOB - \li Character large string object - \li Mapped to QString - \row - \li BLOB - \li A binary large object - \li Mapped to QByteArray - \row - \li TIMESTAMP - \li Year, month, and day values of date, as well as hour, minute, - and second values of time - \li Mapped to QDateTime - \endtable - - \section2 ODBC Data Types - - \table 90% - \header - \li ODBC data type - \li SQL type description - \li Recommended input (C++ or Qt data type) - \row - \li BIT - \li Boolean - \li BOOL - \row - \li TINYINT - \li 8 bit integer - \li typedef qint8 - \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 By default mapping to QString - \row - \li FLOAT - \li 64-bit Double floating point - \li By default mapping to QString - \row - \li DOUBLE - \li 64-bit Double floating point - \li By default mapping to QString - \row - \li CHAR - \li Character string - \li Mapped to QString - \row - \li VARCHAR - \li Character string - \li Mapped to QString - \row - \li LONGVARCHAR - \li Character string - \li Mapped to QString - \row - \li CLOB - \li Character large string object - \li Mapped to QString - \row - \li DATE - \li Character string - \li Mapped to QDate - \row - \li TIME - \li Character Time, Character string - \li Mapped to QTime - \row - \li TIMESTAMP - \li Character Time, Character string - \li Mapped to QDateTime - \endtable - - \section2 PostgreSQL Data Types - - \table 90% - \header - \li PostgreSQL data type - \li SQL type description - \li Recommended input (C++ or Qt data type) - \row - \li BOOLEAN - \li Boolean - \li bool - \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 variable-precision floating point - \li By default mapping to QString - \row - \li DOUBLE PRECISION - \li 64-bit variable-precision floating point - \li By default mapping to QString - \row - \li DECIMAL VARIABLE - \li user-specified precision, exact - \li Mapped to QString - \row - \li NUMERIC VARIABLE - \li user-specified precision, exact - \li Mapped to QString - \row - \li VARCHAR - \li variable-length character string - \li Mapped to QString - \row - \li CHARACTER - \li Character string of fixed-length - \li Mapped to QString - \row - \li TEXT - \li Character string of variable-length - \li Mapped to QString - \row - \li CLOB - \li Character large string object - \li Mapped to QString - \row - \li TIMESTAMP - \li 8 bytes, both date and time - \li Mapped to QDateTime - \row - \li TIMESTAMP - \li 8 bytes, both date and time, with time zone - \li Mapped to QDateTime - \row - \li DATE - \li 4 bytes, dates only - \li Mapped to QDate - \row - \li TIME - \li 8 bytes, times of day only 00:00:00.00 - 23:59:59.99 - \li Mapped to QTime - \row - \li TIME - \li 12 bytes times of day only, with time zone 00:00:00.00+12 - \li Mapped to QDateTime - \endtable - - \section2 QSQLITE SQLite version 3 Data Types - - \table 90% - \header - \li QSQLITE SQLite version 3 data type - \li SQL type description - \li Recommended input (C++ or Qt data type) - \row - \li NULL - \li NULL value. - \li NULL - \row - \li INTEGER - \li Signed integer, stored in 8, 16, 24, 32, 48, or 64-bits - depending on the magnitude of the value. - \li typedef qint8/16/32/64 - \row - \li REAL - \li 64-bit floating point value. - \li By default mapping to QString - \row - \li TEXT - \li Character string (UTF-8, UTF-16BE or UTF-16-LE). - \li Mapped to QString - \row - \li CLOB - \li Character large string object - \li Mapped to QString - \row - \li BLOB - \li The value is a BLOB of data, stored exactly as it was input. - \li Mapped to QByteArray - \endtable - - \section2 Sybase Adaptive Server Data Types - - \table 90% - \header - \li Sybase Adaptive Server data type - \li SQL type description - \li Recommended input (C++ or Qt data type) - \row - \li BINARY - \li Describes a fixed-length binary value up to 255 bytes in size. - \li Mapped to QByteArray - \row - \li CHAR - \li Character String - \li Mapped to QString - \row - \li DATETIME - \li Date and time. Range: 1753-01-01 00:00:00 through 9999-12-31 23:59:59. - \li Mapped to QDateTime - \row - \li NCHAR - \li Character String of fixed length - \li Mapped to QString - \row - \li NVARACHAR - \li Character String of variable length - \li Mapped to QString - \row - \li VARCHAR - \li Character String of fixed length - \li Mapped to QString - \row - \li CLOB - \li Character large string object - \li Mapped to QString - \row - \li TIMESTAMP - \li A unique number within a database - \li Mapped to QString - \row - \li SMALLDATETIME - \li Date and time. Range: 1900-01-01 00:00 through 2079-12-31 23:59 - \li Mapped to QDateTime - \row - \li UNICHAR - \li Character String of fixed length.(Unicode) - \li Mapped to QString - \row - \li UNIVARCHAR - \li Character String of variable length.(Unicode) - \li Mapped to QString - \row - \li VARBINARY - \li Describes a variable-length binary value up to 255 bytes in size - \li Mapped to QByteArray - \endtable - - \section2 SQLite Version 2 - - SQLite version 2 is "typeless". This means that you can store any kind of - data you want in any column of any table, regardless of the declared - data type of that column. We recommend that you map the data to QString. -*/ |