LiveCode Forums.

If I use mySQL workbench and use this query I am able to store a check mark in the database just fine.

update cutlist set checkmark = '✓' where id = '2436'

However when I get data with livecode it is displayed as a ?

Also, if I use the exact same query as above from livecode, a ? is stored in the database.

If there is no way to make this work, a question mark is fine with me because the following code works just fine to make it look like a ✓

replace "?" with "✓" in pOutArrayA[ theField ]

This could be a text encoding issue. Run the command through textDecode before sending it to the database, and use textEncode on incoming data when retrieving it. I'd guess the db is using UTF8.

Use this: Then instead of text, use the htmlText property.

Thank you guys for your help.