Changeset 683 for trunk/lib/DB.inc.php

Timestamp:

May 19, 2019 10:51:34 PM (5 years ago)

Author:

anonymous

Message:

Add support for mysql-specific character sets and collations

File:

• trunk/lib/DB.inc.php (modified) (2 diffs)

trunk/lib/DB.inc.php

@@ -72 +72 @@
         // Timezone for MySQL.
         'timezone' => 'UTC',
+
+        // MySQL character set and collation.
+        'character_set' => '',
+        'collation' => '',
     );
 
@@ -192 +196 @@
         $this->_connected = true;
 
-        // Tell MySQL what character set we're using. Available only on MySQL versions > 4.01.01.
-        if ('' != $app->getParam('character_set') && isset($this->mysql_character_sets[mb_strtolower($app->getParam('character_set'))])) {
-            $this->query(sprintf("SET NAMES '%s';", $this->mysql_character_sets[mb_strtolower($app->getParam('character_set'))]));
-        } else {
-            $app->logMsg(sprintf('%s is not a known character_set.', $app->getParam('character_set')), LOG_ERR, __FILE__, __LINE__);
+        // If the mysql charset is not defined, try to determine a mysql charset from the app charset.
+        if ('' == $this->getParam('character_set') && '' != $app->getParam('character_set') && isset($this->mysql_character_sets[mb_strtolower($app->getParam('character_set'))])) {
+            $this->setParam(array('character_set' => $this->mysql_character_sets[mb_strtolower($app->getParam('character_set'))]));
+        }
+        if ('' != $this->getParam('character_set')) {
+            if ('' != $this->getParam('collation')) {
+                $this->query(sprintf("SET NAMES '%s' COLLATE '%s';", $this->getParam('character_set'), $this->getParam('collation')));
+            } else {
+                $this->query(sprintf("SET NAMES '%s';", $this->getParam('character_set')));
+            }
         }