LiveCode Forums.

I am using LIvecode with SQLite. When I do an Insert directly in SQLite, the French characters are saved and are showing undisturbed. But when I do the same Insert within Livecode, the French characters are not rendered as such. In the database, they are showing as a small square. To open the SQLite database, I use the following code "put revOpenDatabase("sqlite", dbpath,,,,,,) into tConID"
To execute the SQL, I use the code "put revdb_execute(gConID, tSQL) into tTmp"
What am I doing wrong within LIvecode that changes the French characters? What am I supposed to do to fix it?
Thanks everyone.