Re: Flag for insentive use of Postgres? - Mailing list pgsql-general

From Stephane Bortzmeyer
Subject Re: Flag for insentive use of Postgres?
Date
Msg-id 20020710123116.GA15275@nic.fr
Whole thread Raw
In response to Flag for insentive use of Postgres?  (Andreas Schlegel <schlegel@software.b.uunet.de>)
Responses Re: Flag for insentive use of Postgres?
List pgsql-general
On Wed, Jul 10, 2002 at 02:03:30PM +0200,
 Andreas Schlegel <schlegel@software.b.uunet.de> wrote
 a message of 18 lines which said:

> is there a flag to set which determines if queries run successful with a
> case sensitive or case insensitive WHERE clause:

What if the encoding is Unicode, which has no case-folding rules?

> For example: if I have a name1 colum with a value 'Test' I would like to
> search for 'test' and get also this row
> (select * from tTest where name1='test')

And name1 = 'MASSE' when you requested name1 = 'Maße'? So, even with
Latin-1, you have a problem.


pgsql-general by date:

Previous
From: Jürgen Mischke
Date:
Subject: Re: update problem?
Next
From: Oliver Elphick
Date:
Subject: Re: static linkage with libpq?