On Apr 7, 2011, at 2:16 PM, Thomas Coder wrote: > We’re having some trouble with accented characters and hoping someone can > shed some light on the topic. > > We have data in a MySQL database that contains accented characters like > “Nuñéz”, and we want it to display correctly in a datagrid. > > When we retrieve the data, LiveCode sees it as this: NuÒÈz > > When we try this: > set the unicodeText of fld "Field" to uniencode(t, "UTF8") > > the words appears with a square character instead of the “ñé” characters. > > Is there a magic combination of code that fixes this?
Thomas, I'm guessing you're on a Mac? What happens when you do this: -- retrieve the data from your database into variable t put isoToMac(t) into fld "displayfld" The root of your problem is probably that the data is not stored in the database as UTF-8. If it were, the 'set the unicode ...' statement would work. Also, make sure that the textFont for the destination field is set to a unicode font to ensure all of the characters display. Hope this helps. Devin Devin Asay Humanities Technology and Research Support Center Brigham Young University _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
