Hi,
let me introduce myself first: I'm new to this list (but not SQL),
using sqlite3 mostly in order to write exporters from my
face-recognition tool to some photo management software (F-Spot and
Digikam, currently), but also some convenience functions (mostly for
F-Spot).
And that's actually where my problem comes in: newer versions of
F-Spot store the location of a Photo in what I would call URL-encoded
format --- so instead of a space (' ') I see '%20' (and so on). Now,
the problem is that due to a bug in some versions of F-Spot, this
information might have been only partly urlencoded, I might see a name
like "image 1 (modified%20(2)).jpg". Since I can not forsee which
parts might have been encoded and which not, I therefore need to write
something like:
SELECT * FROM table WHERE urldecode(table.name)='some file name';
So I guess my question is: is there such a function "urldecode()", and
if not, what is the best way to solve this problem? Can I define my
own functions in sqlite3 (don't think so, or)? I would appreciate any
ideas...
Sven
--
__ _ _ __ __ __
/ _` || ' \ \ \ / http://www.svenutcke.de/
\__, ||_|_|_|/_\_\ http://www.dr-utcke.de/
|___/ Key fingerprint = 6F F8 55 1C F9 E3 A8 F7 09 DF F7 2C 25 0C 54 53
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
