WordPress.org

Support

Support » Plugins and Hacks » [Resolved] Encoding!

[Resolved] Encoding!

Viewing 6 replies - 1 through 6 (of 6 total)
  • Same Problem …

    Same here (Czech language). The problem is that the table fields use latin1_swedish locale settings.

    I’ve managed to fix it, but please note I only have a very limited understanding of PHP and SQL, so I’m not sure whether this might cause any problems or not! So do at your own risk.

    First, edit the plugin code itself. Find this line:

    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1";

    and change it to:

    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";

    Then, you need to alter the table itself. I’ve done it using the MySQL web console on my hosting, not sure if it’s standard or not. Anyway, you need to locate table wp_simple_posts_templates in your wordpress install database. Then you need to change the collate settings of the individual fields – in my MySQL console, I had to click on the “Structure” tab, check the checkboxes next to title, excerpt and content fields, click Edit and then change the collate charset from “latin1_swedish_ci” to “utf8_general_ci”.

    But then you also need to change the default charset of the whole table, otherwise it will reset back to latin1_swedish. So I’ve ran this SQL command on the table:

    ALTER TABLE `wp_simple_posts_templates` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci

    And done. Now the plugin supports Czech characters just fine.

    Plugin Author Clifton Griffin

    @clifgriffin

    Hi guys,

    I just uploaded version 2.0.6.1 with UTF8 support. Sorry for messing this up!

    Upon activation, it should alter your table to use UTF8 instead of latin1 encoding.

    Clif

    Plugin could not be activated because it triggered a fatal error.

    Parse error: syntax error, unexpected ‘.6’ (T_DNUMBER) in /home/admin/domains/xxxxxx/public_html/ok/wp-content/plugins/simple-post-template/simple-post-template.php on line 35

    Plugin Author Clifton Griffin

    @clifgriffin

    My fault.

    I added some numbers to the version number but didn’t enclose it in a string. Depending on your PHP version, that’s why you would get a fatal error.

    The latest update should fix that.

    So sorry.

    Works great!

    Very helpful plugin!

    Thank you)

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘[Resolved] Encoding!’ is closed to new replies.