Hi Devin Thanks for that. I just tried it and
*Bodø River* becomes *Bod River* I was wondering at what point the Unicode is lost. So is it still intact when it is saved as a variable? and is it then lost when the variable is put into a field? By the way the BYU documentation is the best on LiveCode. ;-) On 25 July 2017 at 23:28, Devin Asay via use-livecode < use-livecode@lists.runrev.com> wrote: > 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 -- Kaveh Bazargan Director River Valley Technologies @kaveh1000 +44 7771 824 111 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