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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
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
