UTF8 chars not supported

  • Resolved selnomeria

    (@selnomeria)


    9 years, 6 months ago

    When i type content with UTF8, then on output page, there are shown question marks ??????????????????????????? instead of chars…
    maybe the plugin doesnt create the database table with UTF8 parameter.

    use like this while creating table:

    ………..
    PRIMARY KEY (IDD),
    UNIQUE KEY IDD (IDD)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1;

    https://www.ads-software.com/plugins/xv-random-quotes/

Viewing 1 replies (of 1 total)
  • Plugin Author Xavi Ivars

    (@xavivars)

    Hi tazo todua,

    I use UTF8 content in my own database and don’t have this problem.

    However, I’ve managed to reproduce this problem: it occurs when your DATABASE is not set to an UTF8 charset (the table creation uses the DB charset).

    I was considering adding support for migrating the content of this particular table to UTF-8, but the complexity of such a migration is probably too high, taking into account that is relativelly easy to achieve the same thing from your DB admin tool (phpMyAdmin, etc).

    What I’ll do is to add what is required to be sure the table always gets created with the right charset.

    Assuming your database is called “wordpress”, your prefix is “wp_” and your actual charset is latin1, here you have the script needed to update your table:
    https://gist.github.com/xavivars/038c734a7850ea07563c

    Let me know if you have any problem.

    Xavi

Viewing 1 replies (of 1 total)
  • The topic ‘UTF8 chars not supported’ is closed to new replies.