https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/100007.aspxTue, 11 Nov 2014 12:17:38 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:100007Larry W. Virden0https://www.infopathdev.com:443/forums/thread/100007.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=100007<p>&nbsp;A co-worker is writing an InfoPath application. Within it, of course, there are a variety of controls. </p><p>The ones that I am wondering about&nbsp;are the text entry controls.</p><p>Traditionally, SQL Server table columns are char or varchar type files. However, most InfoPath text controls allow the user to enter unlimited number of text. This results in applications where a user may paste in text that exceeds what is defined in the database, causing a SQL Server error when the insertion occurs.</p><p>In most of this application&#39;s cases, there isn&#39;t an intended limitation on the number of characters&nbsp;for the information being gathered.</p><p>Some of the controls are single line text, and it is okay&nbsp;to store&nbsp;plain&nbsp;ASCII upper and lower case type text. &nbsp;</p><p>Some of the controls, however, are multi line text that the requirements want Rich Text collected.</p><p>The developer has indicated that this&nbsp;causes him to have to establish rules that copy the text from the control into an XML node, rather than simply associating the XML node to the control like other&nbsp;situations.</p><p>&nbsp;</p><p>This seems quite complicated to me.&nbsp; I am wondering if&nbsp;there are some tutorials on these topics that could be used to&nbsp;gain a better understanding&nbsp;of what is required to make these applications work better.</p><p>&nbsp;</p><p>Thank you&nbsp;</p>