r1734 + explicitly show UTF on install/upgrade
authorDenis Ovsienko <infrastation@yandex.ru>
Tue, 26 Feb 2008 17:44:00 +0000 (17:44 +0000)
committerDenis Ovsienko <infrastation@yandex.ru>
Tue, 26 Feb 2008 17:44:00 +0000 (17:44 +0000)
install/init-structure.sql
upgrade.php

index 5df3cf66ccd27ebcffbf212c90104f32ae302fc5..75d1f087c8d050337130931935d82fdfe97f2204 100644 (file)
@@ -1,3 +1,6 @@
+alter database character set utf8;
+set names 'utf8';
+
 CREATE TABLE `Atom` (
   `molecule_id` int(10) unsigned default NULL,
   `rack_id` int(10) unsigned default NULL,
index 217d35c666053e0aa2f7d0d722653deae23c6e12..d165a52f2b185e90f74a93483f3279f9315eea79 100644 (file)
@@ -794,6 +794,7 @@ CREATE TABLE `IPVirtualService` (
                                foreach ($tmp as $chapter_no => $dict_value)
                                        $query[] = 'INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) ' .
                                                "VALUES (${chapter_no}, ${dict_key}, '${dict_value}')";
+                       $query[] = "alter database character set utf8";
                        $query[] = "update Config set varvalue = '0.14.12' where varname = 'DB_VERSION'";
                        break; // --------------------------------------------
 #              case '0.14.13':