How to store a ✓ in mySQL using livecode

[DavJans]

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 ]

[jacque]

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.

[MaxV]

Use this:

Code: Select all

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

Then instead of text, use the htmlText property.

[DavJans]

Thank you guys for your help.