Changeset 1232

Timestamp:

01/05/09 06:03:31 (2 years ago)

Author:

bermi

Message:

Important: Data integrity issue on MySQL

Before rev.1232 MySQL on some setups, connections where opened using PHP's default
encoding latin1 this caused that UTF8 data written by Akelos could not be edited using other DB tools like phpMyAdmin

This change solves the issue for new applications, but existing applications can fix this by backing up your database
and following the steps at http://codesnippets.joyent.com/posts/show/84 before defining AK_SET_UTF8_ON_MYSQL_CONNECT on your configuration file.

Files:

• trunk/CHANGELOG.txt (modified) (1 diff)
• trunk/config/boot.php (modified) (1 diff)
• trunk/lib/AkActiveRecord/AkDbAdapters/AkMysqlDbAdapter.php (modified) (1 diff)

trunk/CHANGELOG.txt

@@ +1 @@
+[1232] Important: Data integrity issue on MySQL
+
+Before rev.1232 MySQL on some setups, connections where opened using PHP's default 
+encoding latin1 this caused that UTF8 data written by Akelos could not be edited using other DB tools like phpMyAdmin
+
+This change solves the issue for new applications, but existing applications can fix this by backing up your database
+and following the steps at http://codesnippets.joyent.com/posts/show/84 before defining AK_SET_UTF8_ON_MYSQL_CONNECT on your configuration file.
+
-[1205] Adding new configuration script to generate config.php and database.yml
-

trunk/config/boot.php

@@ -21 +21 @@
-defined('AK_LIB_DIR') ? null : define('AK_LIB_DIR',AK_FRAMEWORK_DIR.DS.'lib');
-
+/**
+ *  Before rev.1232 MySQL on some setups, connections where opened using PHP's default 
+ *  encoding latin1 this caused that UTF8 data written by Akelos could not be edited using other DB tools.
+ *  
+ *  We can't automatically fix this for older applications as you might need to backup your database and follow the steps at
+ *  http://codesnippets.joyent.com/posts/show/84 before defining AK_SET_UTF8_ON_MYSQL_CONNECT on your configuration file
+ *  to fix this issue
+ */
+defined('AK_SET_UTF8_ON_MYSQL_CONNECT') ? null : define('AK_SET_UTF8_ON_MYSQL_CONNECT', true);
+
-require_once(AK_LIB_DIR.DS.'constants.php');
-

trunk/lib/AkActiveRecord/AkDbAdapters/AkMysqlDbAdapter.php

@@ -81 +81 @@
-    }
-    
+    function connect($die_on_error=true)
+    {
+        parent::connect($die_on_error);
+        if(defined('AK_SET_UTF8_ON_MYSQL_CONNECT') && AK_SET_UTF8_ON_MYSQL_CONNECT){
+                isset($this->connection->_connectionID) && mysql_set_charset('utf8', $this->connection->_connectionID);
+        }
+    }
+    
-}
-?>