WordPress displays weird characters

Sometimes after a database conversion (e.g. from MySQL to MariaDB) or due to encoding issues a situation might arise when WordPress is showing weird characters. A quick way of remedying the situation would involve examining the pages to discover a pattern (what characters are being substituted, in the example below the apostrophe was replaced by â€™) then running an queries against the database to reverse the effect. Here's a quick example (common tables that store content):



  • UPDATE wp_posts SET post_content = REPLACE(post_content, 'Â''')     
  • UPDATE wp_posts SET post_content = REPLACE(post_content, '’'"'")     
  • UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, 'Â''')     
  • UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, '’'"'")     

  • Please, keep in mind that to permanently resolve the issue you would need to get to the root of the problem and may need to adjust encoding, run a database conversion, or install a sanitizing plugin.

    Comments

    1. blockchain It’s very informative and you are obviously very knowledgeable in this area. You have opened my eyes to varying views on this topic with interesting and solid content.

      ReplyDelete
    2. Pubg Aimbot All the contents you mentioned in post is too good and can be very useful. I will keep it in mind, thanks for sharing the information keep updating, looking forward for more posts.Thanks

      ReplyDelete
    3. seo marketplace Actually I read it yesterday but I had some thoughts about it and today I wanted to read it again because it is very well written.

      ReplyDelete
    4. vigrx plus male enhancement Really appreciate this wonderful post that you have provided for us.Great site and a great topic as well i really get amazed to read this. Its really good.

      ReplyDelete
    5. get traffic Email marketing to get traffic worldwide

      ReplyDelete
    6. เล่น sbobet ฟรี Actually I read it yesterday but I had some thoughts about it and today I wanted to read it again because it is very well written.

      ReplyDelete
    7. $300 Google Adwords and $250 Facebook Ads COUPON Writing with style and getting good compliments on the article is quite hard, to be honest.But you've done it so calmly and with so cool feeling and you've nailed the job. This article is possessed with style and I am giving good compliment. Best!

      ReplyDelete
    8. Oklahoma Hood Cleaning So luck to come across your excellent blog. Your blog brings me a great deal of fun.. Good luck with the site.

      ReplyDelete
    9. free google play codes Super site! I am Loving it!! Will return once more, Im taking your food likewise, Thanks.

      ReplyDelete
    10. link I’ve been searching for some decent stuff on the subject and haven't had any luck up until this point, You just got a new biggest fan!..

      ReplyDelete
    11. Gas Ranges wow... what a great blog, this writter who wrote this article it's realy a great blogger, this article so inspiring me to be a better person

      ReplyDelete
    12. siding contractors I’m excited to uncover this page. I need to to thank you for ones time for this particularly fantastic read!! I definitely really liked every part of it and i also have you saved to fav to look at new information in your site.

      ReplyDelete
    13. arbre de noel Gangaur Realtech is a professionally managed organisation specializing in real estate services where integrated services are provided by professionals to its clients seeking increased value by owning, occupying or investing in real estate.

      ReplyDelete
    14. cocktail Three are usually cheap Ralph Lauren available for sale each and every time you wish to buy.

      ReplyDelete
    15. Wholesale good food additives I have bookmarked your website because this site contains valuable information in it. I am really happy with articles quality and presentation. Thanks a lot for keeping great stuff. I am very much thankful for this site.

      ReplyDelete
    16. CBD Isolate Wholesale All of these posts were incredible perfect. It would be great if you’ll post more updates.

      ReplyDelete
    17. I am a new user of this site so here i saw multiple articles and posts posted by this site,I curious more interest in some of them hope you will give more information on this topics in your next articles. videntes

      ReplyDelete

    Post a Comment

    Popular posts from this blog

    Mail-enabled security groups in Office 365

    User attributes in Office 365

    Skype for Business and VTC Interoperability