When creating a matching question, supplying an answer over 255 characters results in the non-descriptive error message, "Error writing to database. More information about this error."

It would be much better if the response had one or more of these responses: name the field ("Answer 1"), more detailed error ("input is too long for field (255 character limit)"), return the browser to the input form with that field highlighted, etc.

Ideally, this would be implemented as part of Moodle's libraries (not specific to the question import routine), so it would benefit all forms.

A complimentary approach would be to validate the input before submitting or during data entry.

I searched for similar trackers and found some about fields too long, but none for questions in particular, and none that seemed general enough (just from the title, at least) to cover the issue globally. This is the first tracker I've filed, so please let me know if I've missed anything.

We are running 2.3.2+ with MySQL on Ubuntu.