Subject Re: [firebird-support] Case insensitive search on a memo field
Author Stefan Heymann
> I’m using Firebird 2.5.3, and I am looking for text in a emo field, eg.
> I’m tempted to do something like
> Select * from mytable t where lowercase(t.mymemo) like ‘%find me%’
> but since this memo field could be enormous, I’m guessing that wold be horribly inefficient.

I use upper() for that and it's surprisingly fast (lowercase shouldn't
be different).

What you can do is try to use a case insensitive collation like
unicode_ci or unicode_ci_ai, but I don't know if that really speeds
things up.