Problem with select field with ' Character

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?



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

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

maybe better whith addslashes({fieldsname});