Mysql Character Sets
Anyone got any guidance on this?
I have developed a website on my local machine using an installation of MYSQL5. It has the following characater settings (which I now believe to be default):
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:
The issue I'm getting is that on the hosted db it isnt escaping strings the way i want it to.
Before i make the db call to insert a comment from a comment form i'm escaping things (or intending to) like commas etc:
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.
|All times are GMT. The time now is 02:27 PM.|
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0