From 03595aab1ac05e50771e4b16840fa339f6beda0e Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Wed, 5 Apr 2006 22:14:24 +0000
Subject: [PATCH] Small change in MySQL. Seems to work better under any version
 (tested over MySQL 4.1.12, 4.1.16, 5.0.18 and 5.0.19) Bug 5055.
 (http://moodle.org/bugs/bug.php?op=show&bugid=5055)

---
 admin/utfdbmigrate.php | 15 +--------------
 1 file changed, 1 insertion(+), 14 deletions(-)

diff --git a/admin/utfdbmigrate.php b/admin/utfdbmigrate.php
index 873632d022..2b7d8841a8 100755
--- a/admin/utfdbmigrate.php
+++ b/admin/utfdbmigrate.php
@@ -500,19 +500,6 @@ function db_migrate2utf8(){   //Eloy: Perhaps some type of limit parameter here
                             }
                         }
 
-                        //BLOB TIME!
-                        $SQL = 'ALTER TABLE '.$CFG->prefix.$dbtablename.' CHANGE '.$fieldname.' '.$fieldname.' BLOB;';
-
-                        if ($fieldname != 'dummy') {
-                            if ($debug) {
-                                $db->debug=999;
-                            }
-                            execute_sql($SQL, $debug);
-                            if ($debug) {
-                                $db->debug=0;
-                            }
-                        }
-                        
                         /*********************************
                          * Change column encoding 2 phase*
                          *********************************/
@@ -521,7 +508,7 @@ function db_migrate2utf8(){   //Eloy: Perhaps some type of limit parameter here
                         if ($length > 0) {
                             $SQL.='('.$length.') ';
                         }
-                        $SQL .= ' NOT NULL DEFAULT '.$default.';';
+                        $SQL .= ' CHARACTER SET binary NOT NULL DEFAULT '.$default.';';
                         if ($debug) {
                             $db->debug=999;
                         }
-- 
2.39.5