encoding text

doupsy · Post by **doupsy** » Mon Jul 14, 2008 8:59 pm

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

Mark · Post by **Mark** » Mon Jul 14, 2008 10:34 pm

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