<div class="gmail_extra">So I'm not a lunatic after all ;)<br><br><div class="gmail_quote">2012/4/25 Adam Heinz <span dir="ltr"><<a href="mailto:amh@metricwise.net" target="_blank">amh@metricwise.net</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">On Wed, Apr 25, 2012 at 11:06 AM, Nicolas Larcipretti<br>
<<a href="mailto:niclarcipretti@gmail.com">niclarcipretti@gmail.com</a>> wrote:<br>
> Well, in fact those parameters work in a very weird way (IMHO) cause when<br>
> you create a new field using the max lenght, for instance, vtiger uses this<br>
> parameter to create the database field, but, instead of checking if the user<br>
> typed more then X chars, it simply "chops" the string and insert it anyway<br>
> (please guys, correct me if this happens because some deep shit I've made to<br>
> the system). So, if this behavior is ok to you, go ahead and be happy :)<br>
> cause for me it just wasn't.<br>
<br>
</div>This assessment sounds like what we've experienced here as well. We<br>
had a VARCHAR(20) field to record an external purchase order number<br>
and some users were entering multiple PO,PO,PO all into the one field,<br>
and it would truncate at the field length as you described.<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</blockquote></div><br></div>