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 ]
How to store a ✓ in mySQL using livecode
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller
How to store a ✓ in mySQL using livecode
"Det bästa stället att hitta en hjälpande hand är i slutet av din egen arm" förutom här
-
- VIP Livecode Opensource Backer
- Posts: 7238
- Joined: Sat Apr 08, 2006 8:31 pm
- Location: Minneapolis MN
- Contact:
Re: How to store a ✓ in mySQL using livecode
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.
Jacqueline Landman Gay | jacque at hyperactivesw dot com
HyperActive Software | http://www.hyperactivesw.com
HyperActive Software | http://www.hyperactivesw.com
Re: How to store a ✓ in mySQL using livecode
Use this:
Then instead of text, use the htmlText property.
Code: Select all
update cutlist set checkmark = '✓' where id = '2436'
Livecode Wiki: http://livecode.wikia.com
My blog: https://livecode-blogger.blogspot.com
To post code use this: http://tinyurl.com/ogp6d5w
My blog: https://livecode-blogger.blogspot.com
To post code use this: http://tinyurl.com/ogp6d5w
Re: How to store a ✓ in mySQL using livecode
Thank you guys for your help.
"Det bästa stället att hitta en hjälpande hand är i slutet av din egen arm" förutom här