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

Popular posts from this blog

ios - iPhone/iPad different view orientations in different views , and apple approval process -

monitor web browser programmatically in Android? -

c# - Using multiple datasets in RDLC -