09-14-2017, 05:41 PM
Ah, MySQL Strict
This is one of the many things I have pending. We have dedicated a lot of time to making coreBOS work corretly with MySQL Strict mode. The one thing we haven't gotten around to yet is controlling the length of the fields.
In MySQL strict mode, if you try to insert a text into a varchar field that is longer than what fits there, you get an error and the whole process is aborted.
Suppose you have a field defined as varchar(5) and try to insert there STRING, the insert will fail. Before MySQL strict you got your string truncated: STRIN
What needs to be done is to calculate the length of all fields in the database, write that into the vtiger_field table and then add validations accordingly before you try to save.
anyone up to the challenge?
This is one of the many things I have pending. We have dedicated a lot of time to making coreBOS work corretly with MySQL Strict mode. The one thing we haven't gotten around to yet is controlling the length of the fields.
In MySQL strict mode, if you try to insert a text into a varchar field that is longer than what fits there, you get an error and the whole process is aborted.
Suppose you have a field defined as varchar(5) and try to insert there STRING, the insert will fail. Before MySQL strict you got your string truncated: STRIN
What needs to be done is to calculate the length of all fields in the database, write that into the vtiger_field table and then add validations accordingly before you try to save.
anyone up to the challenge?
Joe
TSolucio
TSolucio