Still struggling with this.
When importing the sql file from the original server, the GoDaddy file is converting the data.
ChÃ¢teau becomes ChÃƒÂ¢teau (as an example right out of database with HeidiSQL)
Also, while ChÃ¢teau displays correctly on my public page as well as my admin page,(Château) when I pick it out of a drop down list it will not find a match.
Likewise, it will not match a Keyword search. If my DataAssist Search pages would recognize the pattern I have no problem. The new database is latin1_swedish_ci as is the old one. Both new and old databases have the issue of not matching many of the words with special characters. Viewing Source shows the 'translated' Château.