From: | Andreas Schlegel <schlegel(at)software(dot)b(dot)uunet(dot)de> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Flag for insentive use of Postgres? |
Date: | 2002-07-10 14:46:53 |
Message-ID: | 3D2C48DD.9020909@software.b.uunet.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Stephane Bortzmeyer wrote:
>
>>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 the meantime I got a message with a quite good solution:
... WHERE lower(name1)='test'
The mentioned problem with phrases like 'Maße' is in this application no
problem: For every field value the programm creates some matchcodes
which contain the original value (Maße) and values with replaced
characters( ß -> ss, Ä -> Ae ...). So the user doesn't care if he is
looking for 'Maße' or 'Masse'.
Greetings,
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Stephane Bortzmeyer | 2002-07-10 14:47:25 | Re: Flag for insentive use of Postgres? |
Previous Message | Alex Rice | 2002-07-10 14:46:39 | abuse of inheritance? |