utf 8 - Strange characters appearing in wordpress -
i'm having niggling wordpress problem
whenever i'm adding apostrophe wordpress post create
'
its saving strange set of characters
’
i've used wordpress many times, never encountered problem
i've uninstalled every single plugin, , problem remains
i read somewhere comment out these lines in wp-config.php
doesn't new posts
/** database charset use in creating database tables. */ //define('db_charset', 'utf8'); /** database collate type. don't change if in doubt. */ //define('db_collate', '');
can me? need set charset override somewhere? how??
if strange character stored in db, seems db not set utf8 charset, can uncomment 2 lines in wp-config.php, since not source of problem.
you have comprehensive tutorial how convert character sets wordpress database here short list do:
- make backup of db
maybe better make copy of site on local computer , try below changes there
convert db (this not affect existing tables,just future new created tables)
alter database mydb character set utf8;
convert tables in database not in desired format.
focus on tables wp_posts , wp_postmeta
alter table wp_posts character set utf8
alter table wp_postmeta character set utf8
individually alter each column of each table use correct character set. not simple process, read section of above link regarding columns.
Comments
Post a Comment