Edit Question - KnowledgeHub

Title Body

I'm having the standard MySQL import encoding issue, but I can't seem to solve it. My client has had a WordPress installation running for some time. I've dumped the database to a file, and imported it locally. The resulting pages have a splattering of � characters throughout. I've inspected the database properties on both sides: production: show create database wordpress; CREATE DATABASE `wordpress` /*!40100 DEFAULT CHARACTER SET latin1 */ local: show create database wordpress; CREATE DATABASE `wordpress` /*!40100 DEFAULT CHARACTER SET latin1 */ production: show create table wp_posts; CREATE TABLE `wp_posts` ( `ID` bigint(20) unsigned NOT NULL auto_increment, ... KEY `post_date_gmt` (`post_date_gmt`) ) ENGINE=MyISAM AUTO_INCREMENT=7932 DEFAULT CHARSET=utf8 local: show create table wp_posts; CREATE TABLE `wp_posts` ( `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT, ... KEY `post_date_gmt` (`post_date_gmt`) ) ENGINE=MyISAM AUTO_INCREMENT=7918 DEFAULT CHARSET=utf8 I've spent hours reading forums on how to squash the �, but I can't get anything to work. 99% of the answers say to match the character set between the databases. What I think should work if the following: mysqldump --opt --compress --default-character-set=latin1 -uusername -ppassword wordpress | ssh username@anotherserver.net mysql --default-character-set=latin1 -uusername -ppassword wordpress I've done it using the utf8 char-set as well. Still with the �'s. I've tried modifying the SQL dump directly, putting with utf8 or latin1 in the "SET names UTF8" line. Still with the �'s. Strange Symptoms I'd expect these � characters to appear in place of special characters in the content, like ñ or ö , but I've seen it where there would n

Tags (comma-separated) Cancel