Community

Export to MS SQL Native method: String or binary data would be truncated.

String or binary data would be truncated."

What i must doing?
Columns with default type "Text" create column in DB MSSQL column with type nvarchar(50), but data may be more!
0

Comments

5 comments

  • Avatar
    Feri Santosa


    Hi Taron,

    Is it on ABBYY Flexicapture professional or engine? For AFC Professional you can set the field property > Data Type > validation > maximum length = x (for instance 100) and create tables during export or you can directky go to MSSQL to increase the length of field.





    0
  • Avatar
    Taron133
    I'm writing about ABBYY Flexicapture StandAlone version.
    0
  • Avatar
    Feri Santosa


    I understand.Then the above steps should work.
    0
  • Avatar
    Taron133
    "field property > Data Type > validation > maximum length = x"
    Thank you!
    0
  • Avatar
    Sushi


    ScanAddicted and Taron133,

    Are we sure this is the same thing? Isn't setting the max length just going to give you an error on the field if the number of character exceed that validation rule? So the user would have to fix the field before exporting. You mention "...but the data could be more!" If it could be more than 50, then why not change the VarChar to something larger? I think the max is 4k characters. If you just want to restrict the field to that character length as a rule, then you can just ignore what I mention =)
    0

Please sign in to leave a comment.