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