case senesitive

From: HENAFF Mari-mai FTRD/DMI/LAN <marimai(dot)henaff(at)rd(dot)francetelecom(dot)fr>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: case senesitive
Date: 2000-06-09 12:37:16
Message-ID: 7D59335FDAE0D011A3350060974B1C7202EBCA87@l-mhs3.lannion.cnet.fr
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin


And is it possible to make a query containing an ORDER BY that is not case
sensitive ?

Thanks
Mari-Mai

-----Original Message-----
From: Peter Eisentraut [mailto:peter_e(at)gmx(dot)net]
Sent: Friday, June 09, 2000 2:58 AM
To: HENAFF Mari-mai FTRD/DMI/LAN
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] accent marks

HENAFF Mari-mai FTRD/DMI/LAN writes:

> Is it possible to configure PostgreSQL, so that it is not accent mark
> sensitive when making conditions upon strings on the queries ?

No, you'll have to do that yourself. A simple tr 'âàáéÿ' 'aaaey' etc.
could possibly do on the client side.

--
Peter Eisentraut Sernanders väg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Loïc TREGOUËT 2000-06-09 13:06:29 multi processor
Previous Message Peter Eisentraut 2000-06-09 00:58:04 Re: accent marks