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 …