You are viewing limited content. For full access, please sign in.

Question

Question

Invalid characters in text field

Laserfiche SDK Version 9 Version 8
Updated October 3, 2014
asked on October 1, 2014

I am writing an integration that populates data in a Laserfiche text field.  This data is very random and can contain special characters.  Because of the special characters, I am getting a "Bad field value" error.  Is there a list available of characters that are not allowed in a text field so I can remove/replace these characters prior to saving the field data?

 

Thank you

0 0

Replies

replied on October 3, 2014

So we store our "string" field data in NVARCHAR columns in the database. Microsoft has a TechNet article that says that the NVARCHAR character data type accepts Unicode characters, so my suspicion is that your source data has characters that SQL Server won't accept. Perhaps you can use Fiddler to figure out what the bad characters are.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...