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

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] case insensitive ZSQL queries

is there an easy way to make the following ZSQL query case-insensitive? select * from clients Thanks... Jim -- View this message in context: http://www.nabble.com/case-insensitive-ZSQL-queries-tf4388729.html#a12512815 Sent from the Zope - DB mailing list archive at N