Accented Characters Display

[Devin Asay]

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