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
 

QuestionForm edit

Subject Using an extension
Extension SqlPlugin
Version Foswiki 2.0.3
Status Asked
Related Topics
Topic revision: r2 - 11 Dec 2015, GeorgeClark
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy