From 57b1a54ea8fc79c9c8a49b14e81efa082f6c53b8 Mon Sep 17 00:00:00 2001
From: kados <kados>
Date: Mon, 3 Jul 2006 16:20:40 +0000
Subject: [PATCH] adding collate utf8_general_ci

---
 misc/convert_to_utf8.pl | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/misc/convert_to_utf8.pl b/misc/convert_to_utf8.pl
index d0a129d32a..c6592ff5f8 100755
--- a/misc/convert_to_utf8.pl
+++ b/misc/convert_to_utf8.pl
@@ -13,7 +13,7 @@ my $sth=$dbh->prepare($query);
 $sth->execute();
 while (my @table=$sth->fetchrow_array()){
     print "Altering table $table[0]\n";
-    my $alter_query="ALTER TABLE $table[0] CHARACTER SET UTF8";
+    my $alter_query="ALTER TABLE $table[0] CHARACTER SET UTF8 collate utf8_general_ci";
     my $sth2=$dbh->prepare($alter_query);
     $sth2->execute();
     $sth2->finish();
-- 
2.39.5