revDataFromQuery and umlauts etc.

[Trevor DeVore]

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