Issue with Character sets
I have a php site with a MySQL database. Recently moved site to GoDaddy and I have an issue displaying french language characters.
Everything is fine on old server.
On new server, display is fine in DataAssist Admin pages, but incorrect in the Data Assist Search pages in the public part of my site.
DB collation is identical. Pages are obviously identical.
There is something in the query in the DataAssist Admin pages that is missing in the public pages that forces the correct display, but I cannot find it. The public page uses Data Assist Search
In the reading I have done, I find that it is not enough to simply declare utf-8 in the header because there can be an underlying character set default in the MySQL database but I cannot isolate what (if anything) is present in the DataAssist pages that I am missing in my own pages.