InfoPath Dev

Curious if this type of data type (varchar8000) in SQL 2005 will function correctly in InfoPath 2003.  Will InfoPath truncate anything over 255 characters?  InfoPath didn't give me any errors or issues when I set it up with these data types initially.  I just want to make sure that it can handle it...I suppose I can test it for myself actually...but if someone knows the answer right now that is cool too.  Also, if this an issue then what and how does a form handle text in a form that is greater than 255?

Hi,

 It will truncate the data  to 255 chars, if we give the limit as 255 chars in the db.

First, thanks for the reply. 

This is an issue.  The nature of this form revolves around a job intake process which admins update with progress notes.  Is there any workaround to this?

Actually, I think Anuma meant that if the field in your database is smaller than the amount of characters typed into the field on the form, the form information will be truncated on submission to the database. I don't know of any character length restrictions, unless you set one on a control, via its properties or data validation....

Hi,

You can increase the length for that data type in the db or you can add the length limit for that field in the infopath form.

Thanks everyone for your inputs.  I ended up testing it out and InfoPath doesn't have any limitations really.  My SQL data type was set at varchar8000 and InfoPath handles it just fine.  That is good news.