{"id":4776,"date":"2019-05-30T07:37:38","date_gmt":"2019-05-30T02:07:38","guid":{"rendered":"https:\/\/pheonixsolutions.com\/blog\/?p=4776"},"modified":"2019-05-30T11:17:33","modified_gmt":"2019-05-30T05:47:33","slug":"solution-to-fix-the-character-encoding-mismatch-problem-in-wordpress","status":"publish","type":"post","link":"https:\/\/pheonixsolutions.com\/blog\/solution-to-fix-the-character-encoding-mismatch-problem-in-wordpress\/","title":{"rendered":"Solution to Fix the Character Encoding Mismatch Problem in WordPress"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\">Solution to Fix the Character Encoding Mismatch Problem in WordPress<\/h4>\n\n\n\n<h4 class=\"wp-block-heading\">Date posted: 29\/10\/2019<\/h4>\n\n\n\n<h4 class=\"wp-block-heading\">Introduction<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">After switching my hosting account, therefore we might notice  <strong>special \/ wired  characters <\/strong> on our wordpress blog. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This error is due to we have some issue with\u00a0Database Character Sets in wordpress. If you are facing similar problem, then here is solution for you.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Note:<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">If you are seeing some special characters as mentioned below in your wordpress blog post after moving or changing server, then that is the same issue I\u2019m addressing in this blog article.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00c2 &nbsp; &nbsp;&nbsp;\u00e2\u20ac&#x2122; &nbsp; &nbsp;\u00e2\u20ac\u0153 &nbsp; &nbsp;&nbsp;\u00e2\u20ac\u009d &nbsp;&nbsp;\u00e2\u20ac\u00a6 &nbsp; &nbsp;&nbsp;\u00e2\u20ac\u201c &nbsp; &nbsp;&nbsp;\u00e2\u20ac\u201d &nbsp; &nbsp;\u00e2\u20ac\u2019 &nbsp; &nbsp;\u00e2\u02c6\u0161 &nbsp; &nbsp; &nbsp;\u00e2\u201e\u00afx &nbsp; &nbsp; &nbsp;\u00cf\u20ac &nbsp; &nbsp; &nbsp;\u00e2\u201e\u00af &nbsp; &nbsp; &nbsp;&nbsp;\u00c3\u00b7 &nbsp; &nbsp;\u00e2\u20ac\u02dc<br><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Solution<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"> Most importantly to fix this issue just comment those two line in wp-config.php file.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>After that open&nbsp;<strong>wp-config.php<\/strong>&nbsp;file and locate below coded lines<\/li><\/ol>\n\n\n\n<p class=\"wp-block-paragraph\"> For your ref : \/** Database Charset to use in creating database tables. *\/<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>define(\u2018DB_CHARSET\u2019, \u2018utf8\u2019);<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>define(\u2018DB_COLLATE\u2019, \u201d);<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">2. Similarly, comment bold lines and Save that file. To sum up commenting it should look like<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/define('DB_CHARSET', 'utf8');\n\/\/define('DB_COLLATE', '');<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"> It should have fixed that problem.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Alternate solution:<\/h4>\n\n\n\n<h4 class=\"wp-block-heading\">How we Fixed Special Character Problem using Search and Replace Plugin<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Meanwhile solution to fix this character encoding problem in wordpress is, we need convert our MySQL database to&nbsp;<strong>utf8<\/strong>&nbsp;or&nbsp;<strong>utf8_general_ci&nbsp;<\/strong>character set.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1. Firstly install&nbsp;<a rel=\"noreferrer noopener\" href=\"http:\/\/wordpress.org\/plugins\/search-and-replace\/\" target=\"_blank\">search and replace plugin<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2. In addition install that plugin,<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"> Certainly go to&nbsp;<strong>Tools<\/strong>&nbsp;&gt;&gt;&nbsp;<strong>Search &amp; Replace<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3. For instance&nbsp;<strong>Search in<\/strong>&nbsp;option, check all those option by clicking&nbsp;<strong>All<\/strong>&nbsp;option in that plugin<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">4. On the other hand <strong>Search for<\/strong>&nbsp;enter the wired character and in&nbsp;<strong>Replaced with<\/strong>&nbsp;enter the value which you need to replace. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">click&nbsp;<strong>Go&gt;&gt;<\/strong>&nbsp;button to replace all the special character in wordpress with proper character<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"http:\/\/www.ashout.com\/wp-content\/uploads\/2013\/12\/replacing-wired-character-wordpress.jpg\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/www.ashout.com\/wp-content\/uploads\/2013\/12\/replacing-wired-character-wordpress.jpg\" alt=\"replacing wired character in wordpress\" class=\"wp-image-2333\" \/><\/a><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">That\u2019s it. Now your wordpress will no longer contains any character encoding problem or special characters.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Thanks for using&nbsp;<a href=\"https:\/\/pheonixsolutions.com\/\">pheonix solutions<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You find this tutorial helpful? Share with your friends to keep it alive.<br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Solution to Fix the Character Encoding Mismatch Problem in WordPress Date posted: 29\/10\/2019 Introduction After switching my hosting account, therefore [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1022],"tags":[666],"class_list":["post-4776","post","type-post","status-publish","format-standard","hentry","category-web-architecture","tag-special-wired-character-encoding-mismatch-problem","psol-cat-web-architecture"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/phn2x7-1f2","jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/4776","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=4776"}],"version-history":[{"count":0,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/4776\/revisions"}],"wp:attachment":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=4776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=4776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=4776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}