This question about Using an extension: Asked
SqlPlugin: Accessing mysql-tables with utf-8 encoding
Hi,
when accessing a database table encoded with utf8 sqlplugin output shows 'strange' characters.
To solve this I hardcoded mysql_enable_utf8 => 1 in foswiki/lib/Foswiki/Plugins/SqlPlugin/Connection.pm line 85 ff.
Is there a better solution?
...
my $db = DBI->connect(
$this->{dsn},
$this->{username},
$this->{password},
{
PrintError => 0,
mysql_enable_utf8 => 1,
RaiseError => 1
});
--
BertoldAltaner - 10 Dec 2015
It doesn't look like this extension has been updated for utf-8 yet. In addition to telling mysql that utf-8 is in use, you may also need to convert utf-8 strings read from the database into UNICODE by calling Foswiki::decode_utf8( $theUtf8data ), and send data TO mysql by using Foswiki::encode_utf8( $some-unicode-strings )
--
GeorgeClark - 11 Dec 2015