Dear, i am facing in sql database. Someone hack my site. When i retrieve i found these character Â, –, etc show in my post and page when i edit them. If i remove these, my post content removed. However Site is show fine everything for user. this problem in wp-admin. For your info. Site Shows: (Contant) CID is the most popular series of thrilling crime investigation of Sony Entertainment Television. In the serial the reall stories present to the audiance with facticious character. The story is all around the Police Department and its method of investigation. Watch hindi drama serial CID online. Free episodes and updates of CID available online. Download and watch episodes of CID. Hindi Serials And Hindi Dramas. Watch CID online for free. Star Plus Serial CID episodes are available online to Download and Watch. Youtube Links HD Vedios CID – 1st December 2012 Part 1 CID – 1st December 2012 Part 2 CID – 1st December 2012 Part 3 In WP-Admin CID is the most popular series of thrilling crime investigation of Sony Entertainment Television. In the serial the reall stories present to the audiance with facticious character. The story is all around the Police Department and its method of investigation. Watch hindi drama serial CID online. Free episodes and updates of CID available online. Download and watch episodes of CID. Hindi Serials And Hindi Dramas. Watch CID online for free. Star Plus Serial CID episodes are available online to Download and Watch.            Youtube Links HD Vedios                  CID 1st December 2012 Part 1                  CID – 1st December 2012 Part 2                  CID – 1st December 2012 Part 3
What character set/collation are you using for your database (specifically your text/varchar columns)?
The easiest solution is to restore the site from the last good backup. You DO back up the database and have it emailed to you every day, right? (There's at least one free plugin to do that.)
Thanks for reply. i am using utf-8 (In wp-config.php) /** 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', '');When i found my db. Two table in latin-swedish-ci. (Pic attached)
Sorry that was my mistake, i dont have backup. If you know any best plugin then plz tell me. i m new in this field.
Backup your database now and start to make experiments. 1. Try to chenge those latin fonts. 2. Update wordpress. 3. reisntall wordpress?