Postgres Pro
Downloads
Home   >   mailing lists

Re: accent marks - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: accent marks
Date
Msg-id Pine.LNX.4.21.0006090252480.23619-100000@localhost.localdomain
Whole thread Raw
In response to accent marks  (HENAFF Mari-mai FTRD/DMI/LAN <marimai.henaff@rd.francetelecom.fr>)
List pgsql-admin
Tree view 
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@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden

pgsql-admin by date:

Previous
From: "John Daniels"
Date:
Subject: FreeBSD PostgreSQL7 port and v7.0.2
Next
From: HENAFF Mari-mai FTRD/DMI/LAN
Date:
Subject: case senesitive