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@lists.runrev.com<mailto:use-livecode@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@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 _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
