Hi again, also note, that the unicode-aware LIKE operator does not come for free. A simple
SELECT * FROM entry WHERE note LIKE '%test%' on a moderately large DB of about 100 MB of data is more than three times slower using the ICU extension than without it. 1.14 sec with sqlite3.dll which ships with Python 2.5 3.52 sec with your compiled sqlite3.dll and the icu*.dlls One should take this (and the currently different MSVCR DLLs) into account before including it into the official Windows binary distribution of web2py. I think it depends on the situation if it is worth the benefit of an unicode aware LIKE operator. Kind regards, Markus --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---