Re: [Zope-DB] case insensitive ZSQL queries
> thanks -- it now works like a charm > AFAIR 'ilike' in postgres doesn't properly support i18n characters, so be carefull with that. -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] case insensitive ZSQL queries
thanks -- it now works like a charm Garry Saddington wrote: > > > > On Wed, 2007-09-05 at 16:16 -0700, onsombal wrote: >> is there an easy way to make the following ZSQL query case-insensitive? >> >> select * from clients >> >> >> >> >> >> >> >> >> Thanks... Jim >> >> > If you use Postgresql then change the 'like' to 'ilike'. > Regards > Garry > > ___ > Zope-DB mailing list > Zope-DB@zope.org > http://mail.zope.org/mailman/listinfo/zope-db > > -- View this message in context: http://www.nabble.com/case-insensitive-ZSQL-queries-tf4388729.html#a12521162 Sent from the Zope - DB mailing list archive at Nabble.com. ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] case insensitive ZSQL queries
On Wed, 2007-09-05 at 16:16 -0700, onsombal wrote: > is there an easy way to make the following ZSQL query case-insensitive? > > select * from clients > > > > > > > > > Thanks... Jim > > If you use Postgresql then change the 'like' to 'ilike'. Regards Garry ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db