The issue was one of mixed encoding. Some fields contained data encoded properly as UTF-8; others contained data encoded as something else, probably ISO-8859-1. When imported to a new UTF-8 database, this was causing truncation. My steps to solve this: Copy the original database, wordpress, to a new database, wordpress2. Make sure the collation of … Read more
Can you try setting the DB Charset within wp-config.php? define(‘DB_CHARSET’, ‘utf8_general_ci’); define(‘DB_COLLATE’, ‘utf8_general_ci’); Have a read of this first though: https://codex.wordpress.org/Editing_wp-config.php It can cause problems to an already existing blog to add those lines into wp-config.php, so use with caution. Are you importing this through WordPress or manually through something like PhpMyAdmin? Also, are all … Read more
To move a site from localhost i usually do the following: 1, Install adminer plugin on your localhost (lets you download the database file) 2, Use an FTP to upload all files 3, Change the php config files details to work on host 4, Open the mysql file saved from Adminer and then edit the … Read more
Maybe it is caused by commenting out the charset meta tag? You should have this in your header: <meta charset=”utf-8″ /> You can see in your source that this meta tag is commented out – maybe while debugging this problem. <!–<meta charset=”UTF-8″>–> Additionally you could check if your database settings are set to utf8_general_ci or … Read more
Here’s the solution guys, Steve from SkyVerge helped me figure it out, sorry for no editing it’s 2am and i’m super tired: Hi Steve, It looks like the problem is now fixed.I t was not necessary to change the ‘allow guest login’ as the problem was something else in the end. After much figuring out … Read more
Character encoding issue – black diamond question marks on imported post excerpts
There’s a filter called get_comment_author that you can hook into to modify a comment author’s appearance. add_filter( ‘get_comment_author’, function( $author, $comment_id, $comment ) { // limit to first 10 characters $author = substr( $author, 0, 10 ); return $author; }, 10, 3 );
After migration, all featured images using accentued characters in their file names are displayed “blanked”
It Turns out the problem was with I was using json_enode to convert the data in to json before inserting it in to database and it was causing the encoding of the characters I have used json_encode($url,JSON_UNESCAPED_UNICODE); and now its working properly.
By copying and pasting each dash into a Unicode lookup (linked below), you can see the two characters are different. Your first string contains an En Dash, which is a different character value than the second string, which is a Hyphen Minus. When performing a search, WordPress is searching for the Em Dash value in … Read more