Re: Flag for insentive use of Postgres?

From: Stephane Bortzmeyer <bortzmeyer(at)nic(dot)fr>
To: Andreas Schlegel <schlegel(at)software(dot)b(dot)uunet(dot)de>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Flag for insentive use of Postgres?
Date: 2002-07-10 12:31:16
Message-ID: 20020710123116.GA15275@nic.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jul 10, 2002 at 02:03:30PM +0200,
Andreas Schlegel <schlegel(at)software(dot)b(dot)uunet(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Arjen van der Meijden 2002-07-10 12:31:33 Re: Flag for insentive use of Postgres?
Previous Message Andrew Sullivan 2002-07-10 12:25:35 Re: [pgsql-general] DB GUI Design tool