This question about Using an extension: Asked

SqlPlugin: Accessing mysql-tables with utf-8 encoding


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/ line 85 ff.

Is there a better solution?

my $db = DBI->connect(
 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

QuestionForm edit

Subject Using an extension
Extension SqlPlugin
Version Foswiki 2.0.3
Status Asked
Related Topics
Topic revision: r2 - 11 Dec 2015, GeorgeClark - This page was cached on 09 Jan 2018 - 15:23.

The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License