Item14207: tell MySQL that our strings are utf8

this MySQL-specific setting seems to not impede other drivers (e.g. Pg) also, the flag actually seems to turn on "utf-8 sensitivity", values in a latin1 database column stay latin1 (both existing and new)
foswiki · Nov 2, 2016 · 2a12b98 · 2a12b98
1 parent 69ceaf5
commit 2a12b98
Showing 1 changed file with 1 addition and 1 deletion.
diff --git a/lib/Foswiki/Plugins/DatabasePlugin/Connection.pm b/lib/Foswiki/Plugins/DatabasePlugin/Connection.pm
@@ -35,7 +35,7 @@ sub connect {
 "DBI:$this->{driver}:database=$this->{database};host=$this->{hostname}$sid",
             $this->{username},
             $this->{password},
-            { PrintError => 1, RaiseError => 1 }
+            { PrintError => 1, RaiseError => 1, mysql_enable_utf8 => 1 }
         );
         if ( !$db ) {
             die "Can't open database specified by description '$description'";