コミュニティ

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人中0人がこの記事が役に立ったと言っています

コメント

5件のコメント

  • Avatar
    Permanently deleted user


    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
    Permanently deleted user
    I'm writing about ABBYY Flexicapture StandAlone version.
    0
  • Avatar
    Permanently deleted user


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


    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

サインインしてコメントを残してください。