revDataFromQuery and umlauts etc.

[Christian Langers]

Hi Ian,

I think you're right...

My solution is to use the MacToIso() function for inserting data into  
the db (from within Revolution) and applying the IsoToMac() function  
to the data you retrieved from the SQLite Db....


Christian



Le 20 mai 08 à 10:42, Ian Wood a écrit :

> Does anyone have experience getting accented characters out of an  
> SQLite3 db using revDataFromQuery?
>
> I've had a report of Aperture Assistant messing up any text  
> containing umlauts etc., this turns out to be due to  
> revDataFromQuery doing something weird with the returned data...
>
> I'm running the following SQLite command:
>
> SELECT zpropertyspecificstring from zrksearchableproperty where  
> zpropertyidentifieruuid = "2HyHwq42T6WfG54QHLpk3A"
>
> via:
>
> put revDataFromQuery(,,the propApDBID of stack "apertureLib",(the  
> propsql of me)) into tVID
>
> where the propApDBID of stack "apertureLib" is the DB ID and the  
> propsql of me is the SQLite command.
>
> Expected results, via SQLite Database Browser 1.3 or via the SQLite3  
> command line tool in Terminal:
> ä
> ü
> ë
> ö
> ï
> â
> û
> ô
> ê
> î
> ¥
> å
> ˙
> †
> ©
> `a
> ∆
>
>
> Results via revDataFromQuery:
> aÃà
> uÃà
> eÃà
> oÃà
> iÃà
> aÃÇ
> uÃÇ
> oÃÇ
> eÃÇ
> iÃÇ
> ¥
> aÃä
> Àô
> †
> ©
> `a
> ∆
>
> Is this some kind of encoding problem?
>
> Ian
>
> P.S. Here's the db file:
> http://www.aperture-assistant.com/files/rev/revdatafromquery_test.apdb.zip 
>  (100KB)_______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution