diff options
Diffstat (limited to 'src/sql/doc/src/sql-driver.qdoc')
| -rw-r--r-- | src/sql/doc/src/sql-driver.qdoc | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/src/sql/doc/src/sql-driver.qdoc b/src/sql/doc/src/sql-driver.qdoc index fd95e89812..cccce48bb3 100644 --- a/src/sql/doc/src/sql-driver.qdoc +++ b/src/sql/doc/src/sql-driver.qdoc @@ -381,6 +381,23 @@ multibyte enabled PostgreSQL server can be found in the PostgreSQL Administrator Guide, Chapter 5. + \section3 QPSQL Case Sensitivity + + PostgreSQL databases will only respect case sensitivity if the table or field + name is quoted when the table is created. So for example, a SQL query such + as: + + \snippet code/doc_src_sql-driver.qdoc 39 + + will ensure that it can be accessed with the same case that was used. If the + table or field name is not quoted when created, the actual table name + or field name will be lower-case. When QSqlDatabase::record() or + QSqlDatabase::primaryIndex() access a table or field that was unquoted + when created, the name passed to the function must be lower-case to + ensure it is found. For example: + + \snippet code/doc_src_sql-driver.qdoc 40 + \section3 QPSQL BLOB Support Binary Large Objects are supported through the \c BYTEA field type in |