revDataFromQuery and umlauts etc.

[Ian Wood]

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