Importing Unicode from MySQL

[Kaveh Bazargan]

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