MCL/sf/mw/qt: doc/src/sql-programming/qsqldatatype-table.qdoc@3f74d0d4af4c (annotated)

7 3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	1	/****************************************************************************
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	2	**
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	3	** Copyright (C) 2010 Nokia Corporation and/or its subsidiary(-ies).
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	4	** All rights reserved.
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	5	** Contact: Nokia Corporation (qt-info@nokia.com)
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	6	**
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	7	** This file is part of the documentation of the Qt Toolkit.
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	8	**
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	9	** $QT_BEGIN_LICENSE:LGPL$
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	10	** No Commercial Usage
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	11	** This file contains pre-release code and may not be distributed.
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	12	** You may use this file in accordance with the terms and conditions
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	13	** contained in the Technology Preview License Agreement accompanying
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	14	** this package.
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	15	**
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	16	** GNU Lesser General Public License Usage
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	17	** Alternatively, this file may be used under the terms of the GNU Lesser
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	18	** General Public License version 2.1 as published by the Free Software
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	19	** Foundation and appearing in the file LICENSE.LGPL included in the
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	20	** packaging of this file. Please review the following information to
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	21	** ensure the GNU Lesser General Public License version 2.1 requirements
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	22	** will be met: http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html.
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	23	**
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	24	** In addition, as a special exception, Nokia gives you certain additional
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	25	** rights. These rights are described in the Nokia Qt LGPL Exception
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	26	** version 1.1, included in the file LGPL_EXCEPTION.txt in this package.
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	27	**
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	28	** If you have questions regarding the use of this file, please contact
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	29	** Nokia at qt-info@nokia.com.
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	30	**
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	31	**
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	32	**
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	33	**
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	34	**
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	35	**
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	36	**
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	37	**
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	38	** $QT_END_LICENSE$
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	39	**
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	40	****************************************************************************/
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	41
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	42	/*!
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	43	\page sql-types.html
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	44	\title Recommended Use of Data Types in Databases
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	45
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	46	\ingroup best-practices
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	47
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	48	\section1 Recommended Use of Types in Qt Supported Databases
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	49
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	50	This table shows the recommended data types used when extracting data
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	51	from the databases supported in Qt. It is important to note that the
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	52	types used in Qt are not necessarily valid as input to the specific
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	53	database. One example could be that a double would work perfectly as
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	54	input for floating point records in a database, but not necessarily
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	55	as a storage format for output from the database since it would be stored
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	56	with 64-bit precision in C++.
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	57
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	58	\tableofcontents
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	59
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	60	\section2 IBM DB2 Data Types
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	61
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	62	\table 90%
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	63	\header
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	64	\o IBM DB2 data type
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	65	\o SQL type description
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	66	\o Recommended input (C++ or Qt data type)
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	67	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	68	\o SMALLINT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	69	\o 16-bit signed integer
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	70	\o typedef qint16
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	71	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	72	\o INTEGER
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	73	\o 32-bit signed integer
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	74	\o typedef qint32
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	75	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	76	\o BIGINT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	77	\o 64-bit signed integer
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	78	\o typedef qint64
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	79	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	80	\o REAL
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	81	\o 32-bit Single-precision floating point
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	82	\o By default mapping to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	83	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	84	\o DOUBLE PRECISION
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	85	\o 64-bit Double-precision floating point
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	86	\o By default mapping to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	87	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	88	\o FLOAT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	89	\o 64-bit Double-precision floating point
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	90	\o By default mapping to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	91	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	92	\o CHAR
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	93	\o Fixed-length, null-terminated character string
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	94	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	95	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	96	\o VARCHAR
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	97	\o Null-terminated varying length string
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	98	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	99	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	100	\o LONG VARCHAR
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	101	\o Not null-terminated varying length character string
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	102	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	103	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	104	\o BLOB
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	105	\o Not null-terminated varying binary string with 4-byte string
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	106	length indicator
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	107	\o Mapped to QByteArray
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	108	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	109	\o CLOB
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	110	\o Character large string object
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	111	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	112	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	113	\o DATE
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	114	\o Null-terminated character string of the following format:
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	115	yyyy-mm-dd
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	116	\o Mapped to QDate
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	117	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	118	\o TIME
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	119	\o Null-terminated character string of the following format: hh.mm.ss
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	120	\o Mapped to QTime
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	121	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	122	\o TIMESTAMP
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	123	\o Null-terminated character string of the following format: yyyy-mm-dd-hh.mm.ss.nnnnnn
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	124	\o Mapped to QDateTime
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	125	\endtable
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	126
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	127	\section2 Borland InterBase Data Types
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	128
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	129	\table 90%
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	130	\header
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	131	\o Borland InterBase data type
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	132	\o SQL type description
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	133	\o Recommended input (C++ or Qt data type)
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	134	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	135	\o BOOLEAN
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	136	\o Boolean
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	137	\o bool
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	138	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	139	\o TINYINT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	140	\o 8 bit signed integer
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	141	\o typedef qint8
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	142	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	143	\o SMALLINT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	144	\o 16-bit signed integer
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	145	\o typedef qint16
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	146	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	147	\o INTEGER
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	148	\o 32-bit signed integer
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	149	\o typedef qint32
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	150	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	151	\o BIGINT LONG
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	152	\o 64-bit signed integer
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	153	\o typedef qint64
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	154	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	155	\o REAL FLOAT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	156	\o 32-bit floating point
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	157	\o By default mapping to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	158	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	159	\o FLOAT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	160	\o 64-bit floating point
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	161	\o By default mapping to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	162	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	163	\o DOUBLE
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	164	\o 64-bit floating point
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	165	\o By default mapping to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	166	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	167	\o DOUBLE PRECISION
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	168	\o 64-bit Double-precision floating point
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	169	\o By default mapping to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	170	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	171	\o VARCHAR STRING
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	172	\o Character string, Unicode
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	173	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	174	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	175	\o CLOB
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	176	\o Character large string object
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	177	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	178	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	179	\o DATE
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	180	\o Displays date. Format: 'yyyy-mm-dd'
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	181	\o Mapped to QDate
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	182	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	183	\o TIME
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	184	\o Displays time. Format is 'hh:mm:ss' in 24-hour format
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	185	\o Mapped to QTime
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	186	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	187	\o TIMESTAMP
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	188	\o Displays a timestamp. Format is 'yyyy-mm-dd hh:mm:ss'
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	189	\o Mapped to QDateTime
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	190	\endtable
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	191
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	192	\section2 MySQL Data Types
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	193
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	194	\table 90%
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	195	\header
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	196	\o MySQL data type
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	197	\o SQL type description
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	198	\o Recommended input (C++ or Qt data type)
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	199	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	200	\o TINYINT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	201	\o 8 bit signed integer
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	202	\o typedef qint8
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	203	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	204	\o TINYINT UNSIGNED
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	205	\o 8 bit unsigned integer
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	206	\o typedef quint8
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	207	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	208	\o SMALLINT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	209	\o 16-bit signed integer
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	210	\o typedef qint16
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	211	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	212	\o SMALLINT UNSIGNED
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	213	\o 16-bit unsigned integer
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	214	\o typedef quint16
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	215	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	216	\o INT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	217	\o 32-bit signed integer
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	218	\o typedef qint32
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	219	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	220	\o INT UNSIGNED
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	221	\o 32-bit unsigned integer
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	222	\o typedef quint32
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	223	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	224	\o BIGINT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	225	\o 64-bit signed integer
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	226	\o typedef qint64
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	227	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	228	\o FLOAT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	229	\o 32-bit Floating Point
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	230	\o By default mapping to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	231	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	232	\o DOUBLE
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	233	\o 64-bit Floating Point
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	234	\o By default mapping to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	235	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	236	\o CHAR
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	237	\o Character string
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	238	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	239	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	240	\o VARCHAR
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	241	\o Character string
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	242	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	243	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	244	\o TINYTEXT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	245	\o Character string
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	246	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	247	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	248	\o TEXT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	249	\o Character string
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	250	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	251	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	252	\o MEDIUMTEXT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	253	\o Character string
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	254	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	255	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	256	\o LONGTEXT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	257	\o Character string
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	258	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	259	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	260	\o CLOB
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	261	\o Character large string object
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	262	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	263	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	264	\o all BLOB types
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	265	\o BLOB
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	266	\o Mapped to QByteArray
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	267	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	268	\o DATE
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	269	\o Date without Time
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	270	\o Mapped to QDate
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	271	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	272	\o DATETIME
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	273	\o Date and Time
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	274	\o Mapped to QDateTime
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	275	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	276	\o TIMESTAMP
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	277	\o Date and Time
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	278	\o Mapped to QDateTime
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	279	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	280	\o TIME
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	281	\o Time
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	282	\o Mapped to QTime
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	283	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	284	\o YEAR
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	285	\o Year (int)
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	286	\o Mapped to QDateTime
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	287	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	288	\o ENUM
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	289	\o Enumeration of Value Set
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	290	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	291	\endtable
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	292
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	293	\section2 Oracle Call Interface Data Types
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	294
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	295	\table 90%
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	296	\header
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	297	\o Oracle Call Interface data type
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	298	\o SQL type description
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	299	\o Recommended input (C++ or Qt data type)
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	300	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	301	\o NUMBER
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	302	\o FLOAT, DOUBLE, PRECISIONc REAL
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	303	\o By default mapping to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	304	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	305	\o NUMBER(38)
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	306	\o INTEGER INT SMALLINT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	307	\o typedef qint8/16/32/64
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	308	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	309	\o NUMBER(p,s)
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	310	\o NUMERIC(p,s) DECIMAL(p,s)a
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	311	\o By default mapping to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	312	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	313	\o NVARCHAR2(n)
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	314	\o Character string (NATIONAL CHARACTER VARYING(n) NATIONAL
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	315	CHAR VARYING(n) NCHAR VARYING(n))
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	316	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	317	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	318	\o NCHAR(n)
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	319	\o Character string (NATIONAL CHARACTER(n) NATIONAL CHAR(n)
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	320	NCHAR(n))
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	321	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	322	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	323	\o CHAR(n)
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	324	\o Character string (CHARACTER(n) CHAR(n))
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	325	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	326	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	327	\o CLOB
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	328	\o Character large string object
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	329	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	330	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	331	\o BLOB
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	332	\o A binary large object
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	333	\o Mapped to QByteArray
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	334	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	335	\o TIMESTAMP
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	336	\o Year, month, and day values of date, as well as hour, minute,
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	337	and second values of time
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	338	\o Mapped to QDateTime
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	339	\endtable
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	340
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	341	\section2 ODBC Data Types
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	342
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	343	\table 90%
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	344	\header
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	345	\o ODBC data type
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	346	\o SQL type description
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	347	\o Recommended input (C++ or Qt data type)
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	348	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	349	\o BIT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	350	\o Boolean
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	351	\o BOOL
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	352	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	353	\o TINYINT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	354	\o 8 bit integer
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	355	\o typedef qint8
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	356	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	357	\o SMALLINT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	358	\o 16-bit signed integer
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	359	\o typedef qint16
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	360	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	361	\o INTEGER
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	362	\o 32-bit signed integer
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	363	\o typedef qint32
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	364	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	365	\o BIGINT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	366	\o 64-bit signed integer
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	367	\o typedef qint64
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	368	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	369	\o REAL
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	370	\o 32-bit Single-precision floating point
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	371	\o By default mapping to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	372	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	373	\o FLOAT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	374	\o 64-bit Double floating point
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	375	\o By default mapping to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	376	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	377	\o DOUBLE
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	378	\o 64-bit Double floating point
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	379	\o By default mapping to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	380	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	381	\o CHAR
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	382	\o Character string
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	383	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	384	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	385	\o VARCHAR
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	386	\o Character string
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	387	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	388	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	389	\o LONGVARCHAR
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	390	\o Character string
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	391	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	392	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	393	\o CLOB
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	394	\o Character large string object
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	395	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	396	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	397	\o DATE
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	398	\o Character string
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	399	\o Mapped to QDate
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	400	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	401	\o TIME
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	402	\o Character Time, Character string
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	403	\o Mapped to QTime
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	404	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	405	\o TIMESTAMP
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	406	\o Character Time, Character string
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	407	\o Mapped to QDateTime
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	408	\endtable
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	409
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	410	\section2 PostgreSQL Data Types
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	411
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	412	\table 90%
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	413	\header
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	414	\o PostgreSQL data type
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	415	\o SQL type description
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	416	\o Recommended input (C++ or Qt data type)
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	417	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	418	\o BOOLEAN
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	419	\o Boolean
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	420	\o bool
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	421	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	422	\o SMALLINT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	423	\o 16-bit signed integer
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	424	\o typedef qint16
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	425	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	426	\o INTEGER
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	427	\o 32-bit signed integer
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	428	\o typedef qint32
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	429	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	430	\o BIGINT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	431	\o 64-bit signed integer
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	432	\o typedef qint64
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	433	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	434	\o REAL
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	435	\o 32-bit variable-precision floating point
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	436	\o By default mapping to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	437	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	438	\o DOUBLE PRECISION
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	439	\o 64-bit variable-precision floating point
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	440	\o By default mapping to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	441	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	442	\o DECIMAL VARIABLE
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	443	\o user-specified precision, exact
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	444	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	445	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	446	\o NUMERIC VARIABLE
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	447	\o user-specified precision, exact
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	448	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	449	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	450	\o VARCHAR
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	451	\o variable-length character string
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	452	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	453	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	454	\o CHARACTER
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	455	\o Character string of fixed-length
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	456	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	457	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	458	\o TEXT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	459	\o Character string of variable-length
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	460	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	461	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	462	\o CLOB
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	463	\o Character large string object
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	464	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	465	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	466	\o TIMESTAMP
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	467	\o 8 bytes, both date and time
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	468	\o Mapped to QDateTime
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	469	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	470	\o TIMESTAMP
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	471	\o 8 bytes, both date and time, with time zone
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	472	\o Mapped to QDateTime
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	473	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	474	\o DATE
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	475	\o 4 bytes, dates only
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	476	\o Mapped to QDate
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	477	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	478	\o TIME
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	479	\o 8 bytes, times of day only 00:00:00.00 - 23:59:59.99
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	480	\o Mapped to QTime
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	481	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	482	\o TIME
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	483	\o 12 bytes times of day only, with time zone 00:00:00.00+12
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	484	\o Mapped to QDateTime
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	485	\endtable
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	486
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	487	\section2 QSQLITE SQLite version 3 Data Types
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	488
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	489	\table 90%
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	490	\header
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	491	\o QSQLITE SQLite version 3 data type
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	492	\o SQL type description
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	493	\o Recommended input (C++ or Qt data type)
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	494	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	495	\o NULL
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	496	\o NULL value.
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	497	\o NULL
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	498	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	499	\o INTEGER
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	500	\o Signed integer, stored in 8, 16, 24, 32, 48, or 64-bits
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	501	depending on the magnitude of the value.
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	502	\o typedef qint8/16/32/64
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	503	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	504	\o REAL
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	505	\o 64-bit floating point value.
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	506	\o By default mapping to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	507	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	508	\o TEXT
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	509	\o Character string (UTF-8, UTF-16BE or UTF-16-LE).
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	510	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	511	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	512	\o CLOB
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	513	\o Character large string object
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	514	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	515	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	516	\o BLOB
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	517	\o The value is a BLOB of data, stored exactly as it was input.
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	518	\o Mapped to QByteArray
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	519	\endtable
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	520
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	521	\section2 Sybase Adaptive Server Data Types
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	522
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	523	\table 90%
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	524	\header
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	525	\o Sybase Adaptive Server data type
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	526	\o SQL type description
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	527	\o Recommended input (C++ or Qt data type)
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	528	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	529	\o BINARY
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	530	\o Describes a fixed-length binary value up to 255 bytes in size.
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	531	\o Mapped to QByteArray
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	532	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	533	\o CHAR
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	534	\o Character String
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	535	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	536	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	537	\o DATETIME
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	538	\o Date and time. Range: 1753-01-01 00:00:00 through 9999-12-31 23:59:59.
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	539	\o Mapped to QDateTime
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	540	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	541	\o NCHAR
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	542	\o Character String of fixed length
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	543	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	544	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	545	\o NVARACHAR
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	546	\o Character String of variable length
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	547	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	548	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	549	\o VARCHAR
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	550	\o Character String of fixed length
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	551	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	552	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	553	\o CLOB
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	554	\o Character large string object
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	555	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	556	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	557	\o TIMESTAMP
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	558	\o A unique number within a database
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	559	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	560	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	561	\o SMALLDATETIME
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	562	\o Date and time. Range: 1900-01-01 00:00 through 2079-12-31 23:59
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	563	\o Mapped to QDateTime
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	564	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	565	\o UNICHAR
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	566	\o Character String of fixed length.(Unicode)
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	567	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	568	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	569	\o UNIVARCHAR
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	570	\o Character String of variable length.(Unicode)
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	571	\o Mapped to QString
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	572	\row
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	573	\o VARBINARY
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	574	\o Describes a variable-length binary value up to 255 bytes in size
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	575	\o Mapped to QByteArray
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	576	\endtable
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	577
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	578	\section2 SQLite Version 2
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	579
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	580	SQLite version 2 is "typeless". This means that you can store any kind of
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	581	data you want in any column of any table, regardless of the declared
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	582	data type of that column. We recommend that you map the data to QString.
3f74d0d4af4c qt:70947f0f93d948bc89b3b43d00da758a51f1ef84 Eckhart Koeppen <eckhart.koppen@nokia.com> parents: diff changeset	583	*/

author	Eckhart Koeppen <eckhart.koppen@nokia.com>
	Thu, 08 Apr 2010 14:19:33 +0300
branch	RCL_3
changeset 7	3f74d0d4af4c
permissions	-rw-r--r--