mercredi 22 juillet 2015

Get Unicode Text from SQLite DB

I have an SQLite database that contains values with strange characters like ü, é, etc. SQLite is UTF8 by default and the values look good in a database tool.

Now I need to fill an option menu in Livecode with these values. When I do

put uniencode ("Krüger", "utf8") into tData
set the text of button "option" to tDAta

I get the correct value in the option button but looking strange with big spacings like "K r ü g e r" instead of "Krüger"

If I don't do uniencode I get "Krüger".

I also tried set the unicodetext of button "option" to tData but that gave me one line of chinese or japanse chars or so.

Where is my mistake?

I am using Livecode 7.0.6.

Aucun commentaire:

Enregistrer un commentaire