Just a random idea...but how about selecting all of it and creating a
computed field that does the case conversion and then filter it? it's
not very efficient if you have lots of rows before applying the
filter, but it should work on multiple database types.
On Oct 5, 8:17 pm, KMax <mkostri...@gmail.com> wrote:
> Hello
> Postgres has ILIKE where clawse, but it postgres specific extention.
> Is there way to add .ilike to gluon of web2py DAL ?
> Or is there the way to add .ilike to dal at model initialisation.
>
> I know that .lower could be used to workaround case sensity, but I
> have cyrillic chars and .lower() works on them only
> with .decode('utf-8').lower().encode('utf-8') and more over, does not
> work in dal-query at all.
>
> So, please advise.
