diff options
Diffstat (limited to 'src/sql/doc')
-rw-r--r-- | src/sql/doc/snippets/code/doc_src_sql-driver.qdoc | 13 | ||||
-rw-r--r-- | src/sql/doc/src/sql-driver.qdoc | 17 |
2 files changed, 30 insertions, 0 deletions
diff --git a/src/sql/doc/snippets/code/doc_src_sql-driver.qdoc b/src/sql/doc/snippets/code/doc_src_sql-driver.qdoc index d127bdf8a5..9709deeccb 100644 --- a/src/sql/doc/snippets/code/doc_src_sql-driver.qdoc +++ b/src/sql/doc/snippets/code/doc_src_sql-driver.qdoc @@ -237,3 +237,16 @@ Could not create database object //! [38] QPSQLDriver::getResult: Query results lost - probably discarded on executing another SQL query. //! [38] + +//! [39] +CREATE TABLE "testTable" ("id" INTEGER); +//! [39] + +//! [40] +QString tableString("testTable"); +QSqlQuery q; +// Create table query is not quoted, therefore it is mapped to lower case +q.exec(QString("CREATE TABLE %1 (id INTEGER)").arg(tableString)); +// Call toLower() on the string so that it can be matched +QSqlRecord rec = database.record(tableString.toLower()); +//! [40] 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 |