On May 20, 2008, at 4:42 AM, Ian Wood wrote:
Does anyone have experience getting accented characters out of an SQLite3 db using revDataFromQuery?
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.
-- Trevor DeVore Blue Mango Learning Systems ScreenSteps: http://www.screensteps.com Developer Resources: http://revolution.bluemangolearning.com _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
