Details
-
Improvement
-
Resolution: Unresolved
-
Minor
-
None
-
10.2, 10.3
-
None
-
Unknown
-
Description
When you use a short text field in created from App within Minutes, you are able to enter in a very long text string.
However, when you go to save the record, you get an unhelpful error message about not being able to save the record and the following error appears in the log file:
WARN o.h.u.JDBCExceptionReporter - SQL Error: 1406, SQLState: 22001
ERROR o.h.u.JDBCExceptionReporter - Data truncation: Data too long for column 'XWS_VALUE' at row 1
A better behaviour would be to either:
a) check the length of these fields before submission to ensure the text isn't too long and won't cause a database error and notify the user which fields will have an issue, or
b) if a database error occurs, to try to return a more useful error message as to why the record couldn't be saved.
(at this point, when I cannot save a record, the first thing I do is check my string lengths)