https://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/87415.aspxMon, 25 Feb 2013 19:25:38 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:87415Javiator0https://www.infopathdev.com:443/forums/thread/87415.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=87415<p>Hello,</p> <p>Never mind, after some more research, I&nbsp;tried NVARCHAR(4000), and it worked.</p>https://www.infopathdev.com:443/forums/thread/87410.aspxMon, 25 Feb 2013 18:11:16 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:87410Javiator0https://www.infopathdev.com:443/forums/thread/87410.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=87410<p>Hello,</p> <p>My InfoPath form is used to submit data to a table in a SQL Server database.&nbsp; I have a multi-line text box for the user to enter remarks, and would like to increase the maximum length to something above 255 characters (at least 2500 would be nice).&nbsp; I converted the&nbsp;appropriate column&#39;s data type&nbsp;from NVARCHAR(255) to TEXT, and now I get a note in the Submit Status of my form&#39;s data connection summary that says, &quot;Not allowed - One or more of the columns in the data source has a large binary data type such as text, ntext, hyperlink, or image. Large binary data types are not supported.&quot;</p> <p>Which SQL Server data type would be appropriate for this?&nbsp;What adjustments, if any, do I need to make to my form in order to obtain the desired result?</p> <p>Many thanks for your help!</p>