Search code examples
sqliteunicodelivecode

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" Edit: It appears to be that the Text is displayed in "full width". I am using Tahoma but changing the font does not make a difference.

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.

Solution 
  •       put textDecode(MyVariable,”UTF8”) into NewVariable