Importing Unicode from MySQL

[Devin Asay]

Kaveh,

The unicodeText property and uniEncode function are deprecated. Instead use textDecode as follows:

Download your database data into a variable like tStringFromDatabase. Then,

put textDecode(tStringFromDatabase,”UTF8”) into field “myDBText”

HTH

Devin


On Jul 25, 2017, at 4:24 PM, Kaveh Bazargan via use-livecode <use-livecode at lists.runrev.com<mailto:use-livecode at lists.runrev.com>> wrote:

I know this has been discussed before and I have tried to search for the
answer, but no success.

I am using LiveCode Community, 9.0.0 DP5 on Mac

I have a MySQL database where all fields are formatted as UTF8. I do a
query from LiveCode, and put the result in a field and I lose the non ascii
characters.

I am reading the result into whole_table.

I then tried this:

set the unicodeText of field "whole table" to uniEncode(whole_table,"UTF8")

but the non-ascii characters disappear.

any ideas pls

--
Kaveh Bazargan
Director
River Valley Technologies
@kaveh1000
+44 7771 824 111
www.rivervalleytechnologies.com<http://www.rivervalleytechnologies.com>
_______________________________________________
use-livecode mailing list
use-livecode at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Devin Asay
Director
Office of Digital Humanities
Brigham Young University