Hi,

I get caught out almost weekly on requerying dropdown values fed by a database (MS SQL Server) back to the database and the values don't match because of dropped/invalid characters.

I am at the point that every database dropdown that gets rematched to the database goes through an Ascii stripping function before it populates the dropdown to get rid of the invalid/unwanted characters, but I've struggled to find a spec on this that I can match to.  I've been dialing it in on error and the ascii values present in my datasets, currently my function is set to Ascii 32-126,150.   I was wondering if someone has figured this all out and would provide the ascii range that a Laserfiche Forms database fed dropdown will support, and I'd love documentation on what automatically gets dropped in addition to the odd characters.  For instance a double space get automatically turned into a single space which isn't particularly helpful when I need to requery the data using the previously queried value.

In my ideal world I'd be able to set a different id value and label on database lookup fields and use the id value to do the requery, but until that day manifests...

Any help is appreciated. 

LFForms 11 Update 5. MS Sql Server2016