in-series plugin does not support multi-character(ex: chinese)

  • yusiye

    (@yusiye)


    16 years, 5 months ago

    WordPress database error: [Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ‘=’]
    SELECT series_id FROM wp_in_series_3_0_6_series WHERE series_name=’测试’ AND owner_id=’14’

    WordPress database error: [Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ‘=’]
    SELECT series_id FROM wp_in_series_3_0_6_series WHERE series_name=’测试’ AND owner_id=’14’

    Warning: Cannot modify header information – headers already sent by (output started at /home/.stevens/freemoren/freemoren.com/wp-includes/wp-db.php:160) in /home/.stevens/freemoren/freemoren.com/wp-includes/pluggable.php on line 391

    here’s the error result i got. Hope this will be corrected in future release.
    Thank you for the great plugin!

Viewing 1 replies (of 1 total)
  • quandary

    (@quandary)

    16 years, 5 months ago

    I would prefer any support requests be directed to the plugin’s site, either via comments, the contact form, or a message posted to the mailing list. I do not, as a rule, monitor these forums.

    The issue here is that your database’s default character set is not UTF-8 (or some Chinese-specific charset). In Series uses the database’s default character set for all string fields, whereas WordPress (by default) overrides to use UTF-8 (it can be overriden to use other charsets).

    In Series probably should use $wpdb->charset to determine the character set/collation. It doesn’t right now, for a variety of reasons. It does still work for all MySQL configurations that use UTF-8 (or any other character set that’s appropriate for your region) by default. Gentoo (my development platform) configures MySQL to use UTF-8 by default, though a completely unconfigured MySQL will default to latin1 (the behavior that you’re experiencing).

Viewing 1 replies (of 1 total)
  • The topic ‘in-series plugin does not support multi-character(ex: chinese)’ is closed to new replies.