Accented Characters Display

[Thomas Coder]

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