LiveCode Forums.

Hello,

I am hobbyist developper.
I am trying to learm about databases and Revolution.
When I create a database with Revolution (with SQLite) and put data into it, after, wher I open this Data Base with Safari (I am under OS X 10.4 PPC), I have some bad characters.
For example (I am french): the é (chartonum = 142) becomes È (chartonum = 233).
(I am under "French numeric").

I don't know what I must do ?
I don't understand uniencodetext, uniencode, unidecode, binaryencore, binarydecode, binary64encode, etc....

Thanks

Hi Doupsy,

To display text created by Revolution, you need to include a metatag to define the charset in your HTML page. This is ISO 8859 if your stack is running in Windows and MacRoman on Mac OS X.

I am not completely sure how SQLite affects the charset. It might be that SQLite converts everything to ISO 8859, regardless of the platform. You'll need to experiment with that, or maybe someone else knows.

It might be easier to save all text as htmlText, if your HTML-based system can handle that.

Best,

Mark