diff options
| -rw-r--r-- | includes/database/mysql/database.inc | 2 | ||||
| -rw-r--r-- | includes/database/pgsql/database.inc | 2 | ||||
| -rw-r--r-- | includes/database/sqlite/database.inc | 5 |
3 files changed, 8 insertions, 1 deletions
diff --git a/includes/database/mysql/database.inc b/includes/database/mysql/database.inc index 60191db0a..23470abc3 100644 --- a/includes/database/mysql/database.inc +++ b/includes/database/mysql/database.inc @@ -29,6 +29,8 @@ class DatabaseConnection_mysql extends DatabaseConnection { PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => TRUE, // Because MySQL's prepared statements skip the query cache, because it's dumb. PDO::ATTR_EMULATE_PREPARES => TRUE, + // Force column names to lower case. + PDO::ATTR_CASE => PDO::CASE_LOWER, )); // Force MySQL to use the UTF-8 character set by default. diff --git a/includes/database/pgsql/database.inc b/includes/database/pgsql/database.inc index 6393eaebe..04e403222 100644 --- a/includes/database/pgsql/database.inc +++ b/includes/database/pgsql/database.inc @@ -30,6 +30,8 @@ class DatabaseConnection_pgsql extends DatabaseConnection { parent::__construct($dsn, $connection_options['username'], $connection_options['password'], array( // Convert numeric values to strings when fetching. PDO::ATTR_STRINGIFY_FETCHES => TRUE, + // Force column names to lower case. + PDO::ATTR_CASE => PDO::CASE_LOWER, )); } diff --git a/includes/database/sqlite/database.inc b/includes/database/sqlite/database.inc index 769653f59..7f3d521cf 100644 --- a/includes/database/sqlite/database.inc +++ b/includes/database/sqlite/database.inc @@ -31,7 +31,10 @@ class DatabaseConnection_sqlite extends DatabaseConnection { $this->transactionSupport = isset($connection_options['transactions']) ? $connection_options['transactions'] : TRUE; - parent::__construct('sqlite:'. $connection_options['database'], '', '', $connection_options); + parent::__construct('sqlite:'. $connection_options['database'], '', '', array( + // Force column names to lower case. + PDO::ATTR_CASE => PDO::CASE_LOWER, + )); $this->exec('PRAGMA encoding="UTF-8"'); |