I created a DB in MySQL with latin collation and when I tried to save some Unicode content it go saved as “???” into the DB. Took me a while to figure out the issue. When such problem occures you need to change the collation to UTF-8 as shown in the image below. (navigate to […]
How to Turn Off MySQL Strict Mode
I’m helping my boss to set-up a Mambo CMS. When I was trying to insert a post, it was giving an error message. Later I found that I need to turn-off the strict mode of MySQL to avoid this error. This can be done very easily. Run the following query SET @@global.sql_mode= ”; Or else […]