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
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
On 20 May 2008, at 10:17, Christian Langers wrote:
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
I'm pretty sure it's an
I get the same results when using SQLite Database Browser to insert
data with umlauts and retrieving it from within Rev ; fortunately my
app inserts data into the DB, and therefore I can encode the data to
the ISO-Format and back to MAC-Format when I need the data. That's
working for me
I'm only ever retrieving data put in there by Aperture, so the
handlers don't help much.
It's the way Rev is returning different data from other methods of
accessing the DB that's getting to me...
Ian
On 20 May 2008, at 10:44, Christian Langers wrote:
I get the same results when using
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
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 --