Hello Igor, > On 6/17/2011 5:36 PM, Sven Utcke wrote: > > 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';
Actually, the above would be awfully slow (as it can not use the index). It might be better to use an intermediate table (but of course still filled using urldecode()), what is the recommended way to create such a table in sqlite3 (and have it dropped on exit)? > > So I guess my question is: is there such a function "urldecode()" > > No. > > > and > > if not, what is the best way to solve this problem? > > http://sqlite.org/c3ref/create_function.html Thanks. I'm actually using the Python interface, but this set me on the right track. 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
