Re: Flag for insentive use of Postgres?

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.