That did the trick! Now on Windows, the ñ has an accent instead of ˜.
Also, now knowing this, is there something special we should do when using LiveCode to insert data into the database? Thomas On Thu, Apr 7, 2011 at 1:35 PM, Devin Asay <devin_a...@byu.edu> wrote: > > 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 > 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 > _______________________________________________ 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