New to the community? Start here

The Membership plugin doesn't support unicode

Name of the membership levels and subscriptions doesn’t support utf-8?

Sun, 4 Aug 2013 5:01:40
  • aristath
    • Recruit

    Hello there @Yuming, I hope you’re well today!

    Have you checked that ALL your database tables are utf8? Membership creates some new tables so if your server is not set-up to use utf8 as the default collation for database tables, you might have to change them manually using something like phpMyAdmin.

    I hope that helps…

    Cheers,

    Ari.

  • Yuming
    • WPMU DEV Initiate

    Thanks for the tip! Now the problem has been solved.

    The problem is caused by Collation of that table.

    “latin1_swedish_ci” will have unicode characters “?????”

    Hope the issue can be fixed in the next version.

  • aristath
    • Recruit

    @Yuming thank you for letting us know!

    latin1_swedish_ci is the default collation that is set on your server, this has nothing to do with the plugin! When new tables are created, MySQL automatically assigns a collation to that table. If this is a VPS or dedicated server, you can change this by following the instructions on http://dev.mysql.com/doc/refman/5.0/en/charset-server.html and setting the default collation to utf8, or even more easily by adding this to your my.cnf configuration and restarting mysql:

    [mysqld]

    default-collation=utf8_general_ci

    If it’s on a shared hosting server you can ask your host to do this change for you.

    Take care,

    Ari.