[Koha-cvs] koha/misc convert_to_utf8.pl [dev_week]
Joshua Ferraro
jmf at kados.org
Mon Jul 3 18:20:40 CEST 2006
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();
More information about the Koha-cvs
mailing list