Mysql Database Multi language Problem
My problem is I have set Collation=utf8_bin for Title field.
I am using Hindi Language. So when I insert from frontend, the output goes in backend properly like if we insert an English language word, it will be stored in as English, if I insert Hindi language word, it will be stored in as Hindi. Things are working perfectly in my Local but when I do the same in Live....., it is not working. I set the Title field Collation=utf8_bin.
But now when I insert another language word from frontend then whole table's Title field is getting changed to combination of some numeric & string values & it is not working properly.
So what should I do for it?
My Local Mysql Server Version is - 5.1.41
My Live Mysql Server Version is - 5.5.23