Problem with select field with ' Character

Applications Grid / Reports
, ,
#1

Hi to everybody!
I have a problem with che ’ (apostrophe) character.
If i use a select field in a control app and i select a value with ’ character it shows the errore “Invalid data”.
May be a problem with UTF8 setting?

Thanks

Michele

#2

Did you try to replace ’ by /’. ? Works for sql queries.

#3

maybe
you can escape whith twice the ‘, the can’t comes can’‘t or " ’ " or /’

#4

maybe better whith addslashes({fieldsname});