[Koha-cvs] koha/misc convert_to_utf8.pl [dev_week]

[Joshua Ferraro]

CVSROOT:        /sources/koha
Module name:    koha
Branch:         dev_week
Changes by:     Joshua Ferraro <kados>  06/07/03 16:20:40

Modified files:
        misc           : convert_to_utf8.pl 

Log message:
        adding collate utf8_general_ci

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/misc/convert_to_utf8.pl?cvsroot=koha&only_with_tag=dev_week&r1=1.1.2.1&r2=1.1.2.2

Patches:
Index: convert_to_utf8.pl
===================================================================
RCS file: /sources/koha/koha/misc/Attic/convert_to_utf8.pl,v
retrieving revision 1.1.2.1
retrieving revision 1.1.2.2
diff -u -b -r1.1.2.1 -r1.1.2.2
--- convert_to_utf8.pl  8 May 2006 15:19:42 -0000       1.1.2.1
+++ convert_to_utf8.pl  3 Jul 2006 16:20:40 -0000       1.1.2.2
@@ -13,7 +13,7 @@
 $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();