[Vtigercrm-developers] [vtigercrm-developers] UITYPE & TYPEOFDATA map for vtiger 5.x

[Adam Heinz]

On Wed, Apr 25, 2012 at 11:06 AM, Nicolas Larcipretti
<niclarcipretti at gmail.com> wrote:
> Well, in fact those parameters work in a very weird way (IMHO) cause when
> you create a new field using the max lenght, for instance, vtiger uses this
> parameter to create the database field, but, instead of checking if the user
> typed more then X chars, it simply "chops" the string and insert it anyway
> (please guys, correct me if this happens because some deep shit I've made to
> the system). So, if this behavior is ok to you, go ahead and be happy :)
> cause for me it just wasn't.

This assessment sounds like what we've experienced here as well.  We
had a VARCHAR(20) field to record an external purchase order number
and some users were entering multiple PO,PO,PO all into the one field,
and it would truncate at the field length as you described.