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

monitor web browser programmatically in Android? -

Shrink a YouTube video to responsive width -

wpf - PdfWriter.GetInstance throws System.NullReferenceException -