I agree the behavior should be uniform. The easiest way is to make the LIKE always case insensitive. I am patching trunk to use ILIKE with postgresql.
On Jan 28, 3:01 am, KMax <mkostri...@gmail.com> wrote: > On 7 дек 2010, 00:31, Fran <francisb...@gmail.com> wrote: > > > - minimally it should be in a FAQ (ideally in the next Book) & ideally > > we could have a case_sensitive=True option for the DAL like() > > operator...to ensure that both pgsql & mysql/sqlite existing apps > > didn't break, it could default differently depending on the db type? > > +1 vote > sqlite has some issue with not ascii chars compare, but work in > progress > pgsql has ilike which works like mysql like (fix me) > > I' just patch dal to use ilike in .like() query for postgres, but it > more cheat then solution.
