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