just noticed when using the uniencode/unidecode method (as was described in revdataFromQuery and umlauts etc. thread some time ago) to diplay data loaded from sqlite database in compiled application (Windows, Rev 2.9) some unicode Eastern European fonts turn into black sticks. In development environment everything works and fonts are rendered correctly. Fonts are included during compilation and revfont.dll is present in externals folder. What else is there to check for ? Or is this a failure of revFont external and it is time to visit the QC?

Best wishes
Viktoras

Ian Wood wrote:

On 20 May 2008, at 14:42, Trevor DeVore wrote:

You are probably dealing with encoding issues. Maybe the data is stored as UTF8? In that case you would have to do the following:

put uniencode(tVID, "UTF8") into tVID -- change to UTF16 which Rev undestands. put unidecode(tVID) into tVID -- Now it is in a format specific to platform.

I store all unformatted text in SQLite as UTF8 and run it through similar functions.

Bingo! Presumably SQLite Browser and the SQLite command tool are both doing this step automatically.

Thanks Trevor!

Ian
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to