Skip to main content

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. 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
    3. 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
    4. get traffic Email marketing to get traffic worldwide

      ReplyDelete
    5. เน€เธฅ่เธ™ 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
    6. $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
    7. 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
    8. free google play codes Super site! I am Loving it!! Will return once more, Im taking your food likewise, Thanks.

      ReplyDelete
    9. 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
    10. 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
    11. 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
    12. 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
    13. cocktail Three are usually cheap Ralph Lauren available for sale each and every time you wish to buy.

      ReplyDelete
    14. 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
    15. CBD Isolate Wholesale All of these posts were incredible perfect. It would be great if you’ll post more updates.

      ReplyDelete
    16. 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
    17. dog leash I admit, I have not been on this web page in a long time... however it was another joy to see It is such an important topic and ignored by so many, even professionals. I thank you to help making people more aware of possible issues.

      ReplyDelete

    Post a Comment

    Popular posts from this blog

    Skype for Business and VTC Interoperability

    Skype for Business (SfB) has a very, very strong potential, I have written about it in my previous post . I can't think of any other platform that shows as much promise in terms of bridging personal and business communications as well as unifying different modes and mediums. And all of this may have started with a strategic acquisition of Skype by Microsoft in 2011. That said, the road ahead is not without challenges. For example, interoperability with other platforms. Making SfB work with existing Video TeleConferencing (VTC) systems, many of which represent significant capital investments in organizations' infrastructure, could be of a particular importance. After reading statements like Skype for Business is based on Session Initiation Protocol (SIP) standards and supports H.264 (MPEG-4 video coding standard) one can come to a quick conclusion that integration and/or interoperability with other VTC solutions is easy or nearly automatic. Unfortunately, the industry is not

    Mail-enabled security groups in Office 365

    Another update (11/19/2013):  further evolution of Office 365 services makes creation of distribution and security groups even easier, plus there's now an option of creating a dynamic distribution group (click here for more information):    Update (08/06/2012): a clear sign of Office 365 evolving along the same lines as other agile cloud services - small incremental features and minor new functionality are being delivered almost continuously and, unlike important major service updates,  without much fanfare. For example, there's no need to resort to using PowerShell to setup mail-enabled security groups anymore, it can now be done at creation using management portal:       Those managing Office 365 ( O365 ) tenant via the Microsoft Online Services Portal  ( MOS Portal ) interface would notice that there are two distinct group entities: Security Groups: can be created via MOS Portal (main portal page>Management>Security Groups) and used for assigning