I appreciate your clear response.
I use 2 different types of database backup files.
1 is direct from wordpress dashboard
ENGINE=MyISAM AUTO_INCREMENT=4888 DEFAULT CHARSET=latin1 ;
1 is direct from cpanel
ENGINE=MyISAM AUTO_INCREMENT=4341 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
I have also changed my database wp posts table to collate to utf8_general_ci
But it doesn’t seem to work.
Your second fix is very tedious involving 1000+ posts.
First, set the collation on the new database to match the old one.
Do I get you correct? I need to create a new database and move everything from old to new?