When i deployed the website to a shared hosting server which has a MYSQL5 database also but different character settings the way the website handles escaped strings has changed. The character set settings on the hosted db are:
On the local instance of the website a string such as "Jim's Comment" will be inserted as "Jim's Comment" but on the hosted db its inserted as "Jim\'s Comment". Thats just one example of the issues i'm having.
Questions I have are what are the implications of not using the default Mysql character set settings and if i was to reset my local machine to match the settings on the hosted service db how can I get the real_escape_string function to escape the relevant characters? Should my hosted service be reset to the dafault character set settings? Which way should I go?
Any help would be much appreciated as i've done a fair bit of reading on this but nothing thats got it clear in my head yet.