General

Re: Data Type Question: varchar8000 SQL Server 2005 & InfoPath 2003

ZaiZai — Wed, 03 Dec 2008 11:41:13 GMT

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.

Re: Data Type Question: varchar8000 SQL Server 2005 & InfoPath 2003

Anuma — Wed, 03 Dec 2008 04:27:00 GMT

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.

Re: Data Type Question: varchar8000 SQL Server 2005 & InfoPath 2003

Hilary Stoupa — Tue, 02 Dec 2008 18:06:02 GMT

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....

Re: Data Type Question: varchar8000 SQL Server 2005 & InfoPath 2003

ZaiZai — Tue, 02 Dec 2008 10:56:07 GMT

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?

Re: Data Type Question: varchar8000 SQL Server 2005 & InfoPath 2003

Anuma — Tue, 02 Dec 2008 10:48:16 GMT

Hi,

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

Data Type Question: varchar8000 SQL Server 2005 & InfoPath 2003

ZaiZai — Tue, 02 Dec 2008 10:40:42 GMT

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?