Limit setting on entering data in mysql

Question

Looks for a specific configuration in mysql database, formerly had a server with mysql installed (not by me), when I performed a query of Insert/update that had a content above the allowed it cut the content to the limit set in the table configuration, for example. If I try to insert '1234567890' in a field that the limit is 5 characters, instead of returning me the error 'Data Too long for column' it cuts the content to the limit of the capo in this case '12345'. I migrated from server and it does not have this configuration, it returns me the error above, which configuration should perform, the server is a Centos

Answer 1

In the archive my.ini should be as STRICT, in sql-mode:

• https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html

• https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html#sql-mode-Strict

• STRICT_ALL_TABLES

  Enable strict SQL mode for all storage engines. Invalid data values are rejected

• STRICT_TRANS_TABLES

  Enable strict SQL mode for transactional storage engines and when possible for nontransactional storage engines

Disable yourself by configuring sql-mode will be permissive, despite recommending that you adjust this in the application, I mean, setting for the user to know that he has passed the data limit, validate the data entries, because actually cutting a text or entering an invalid date can be a problem.