Forum Post Entry – Strange Characters Being Added – Character Set Problem?

  • OK,

    This is a rather simple problem, at least to explain. It’s a wordpress site with a bbPress forum, but every time I type ￡ and save (or edit) the post, it will replace ‘￡’ with ‘?￡’

    After some Googling, I think it might have something to do with my character set settings or coalition? But this is where it’s troubling for myself.

    For more information, I’ve checked my database as the ‘?￡’ is being stored (i.e. it seems to be an input issue rather than retrieval).

    My wp-config.php shows:

    /** Database Charset to use in creating database tables. */
    define(‘DB_CHARSET’, ‘utf8’);

    /** The Database Collate type. Don’t change this if in doubt. */
    define(‘DB_COLLATE’, ”);

    The wp-tables have Collation of utf8mb4_general_ci

    Many thanks

Viewing 2 replies - 1 through 2 (of 2 total)

  • I am also facing this issue on my local installation over XAMPP .. strange!

    Thread Starter cooper1210

    (@cooper1210)

    I came up with a quick hack and added a trigger to my database:

    BEGIN
    SET
    NEW .post_content = REPLACE (NEW .post_content, ‘?’,” );
    END

    Essentially this just replaces ? with nothing, you can replace that with whatever characters are causing you problems

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Forum Post Entry – Strange Characters Being Added – Character Set Problem?’ is closed to new replies.