Thank you very much to all who have sent me answers. When jacque told me it was UTF-16 I put:
Code: Select all
put textDecode (revDataFromQuery (tab, cr, gDatabaseID, tQuery), "UTF-16") into tData
Code: Select all
put textDecode (revDataFromQuery (tab, cr, gDatabaseID, tQuery), "UTF-8") into tData
.
Anyway, I still have doubts. I have put in the preferences of, DB Bowser for SQLite, that the tables that you create are UTF-16. I have created a table with this configuration and I continue with the same problems. If I put textDecode (tData, "UTF-8") it looks correctly. If it's UTF-16, would not it have to look good in the first place?
Regards,
Carles