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!
What i must doing?
Columns with default type "Text" create column in DB MSSQL column with type nvarchar(50), but data may be more!
Comments
5 comments
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.
I understand.Then the above steps should work.
Thank you!
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 =)
Please sign in to leave a comment.