Home > mailing lists

Case Insensitive & Accent Insensitive - Mailing list pgsql-general

From	icaro
Subject	Case Insensitive & Accent Insensitive
Date	January 26, 2005 16:25:35
Msg-id	002c01c503a9$fd401980$7e3b8c0a@hacer.ula.ve Whole thread Raw
List	pgsql-general

Hello,

We have an application we want to migrate to PostGreSQL. Our application uses a lot of

queries comparing strings with Like and =. It is an application for libraries and we need to do

the comparisons in a case insensitive and accent insensitive way.

We are trying to save time. We have about 700 queries in our app we had to change if

we choose an option as using regular expresions or upper(). And these option does not

solve all the problems.

I would like to know if there is an easier way which does not involve to change the 700

queries. It could be, for example, to change the character set of the database.

Thank you very much,

Ícaro Alzuru C.

From: "Frank D. Engel, Jr."
Date: 26 January 2005, 16:17:34
Subject: Re: text field constraint advice

From: "Marcel Gsteiger"
Date: 26 January 2005, 16:29:34
Subject: cleanup of pg_temp schemas