summaryrefslogtreecommitdiffstats
path: root/doc/src/sql/sql-programming/qsqldatatype-table.qdoc
diff options
context:
space:
mode:
authorCasper van Donderen <casper.vandonderen@nokia.com>2012-04-27 15:18:27 +0200
committerQt by Nokia <qt-info@nokia.com>2012-04-28 13:53:46 +0200
commit00b961c37f82977615ab9c4d03e185229cc55154 (patch)
treebc9012d3ac08c19f2a66b5733dd8450506742243 /doc/src/sql/sql-programming/qsqldatatype-table.qdoc
parent82fa92b23cca834481571f0b0a5d66bc33a672e9 (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.qdoc570
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.
-*/