How to turn off MySQL STRICT mode

Sometimes MySQL STRICT mode cause Zencart to throw the following error: PHP Fatal error: 1406:Data too long for column ‘products_name’ at row 1 To resolve this issue you need to turn off MySQL STRICT mode. You can achieve this by two methods. 1. Edit MySQL global configuration file Open MySQL …

Converting database from Latin1 to UTF8.

Before going to conversion step I wish to add some information about UTF-8 character set. UTF-8 character is prepared for world domination, but Latin1 isn’t. If you wish to allow users to post their own languages, and if you want users from all countries to participate, then you have to …