Increase 255 max character limit - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Increase 255 max character limit

Last post 02-19-2014 01:46 PM by Diana Hallam. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 12-13-2013 08:52 AM

    Increase 255 max character limit

    What control and data type can be used to get a max 4000 character limit to a SQL back-end?

     

    Thanks in advance,

     Diana  

  • 12-19-2013 07:32 PM In reply to

    Re: Increase 255 max character limit

     Hi Diana,

    Have you tried NVARCHAR(MAX)? From what I know that should allow you to store 4000 UCS-2 characters.

     

     Regards,

    Mo Alshorbaji

    Mohammad Alshorbaji
    Qdabra® Software / InfoPathDev.com / 877.544.2389
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™
  • 02-19-2014 01:46 PM In reply to

    Re: Increase 255 max character limit

     Yes, but the limitation seems to be at the data connection in InfoPath.  The data connection will not allow submitting to the database with the field type being NVARCHAR(MAX) set in the SQL field level.

     I hope that makes sense.

     Thanks

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.