Re: upper and UTF-8 - Mailing list pgsql-admin

From Michael Gould
Subject Re: upper and UTF-8
Date
Msg-id 7b16f36ed403d2ac22ac1c93073c41ed@intermodalsoftwaresolutions.net
Whole thread Raw
In response to upper and UTF-8  ("Benjamin Krajmalnik" <kraj@servoyant.com>)
List pgsql-admin

Benjamin,

We're using the contrib module citext for all text columns so that we can do case insensitive searches and so far we haven't found any that it doesn't find.

Best Regards

Mike Gould

 

"Benjamin Krajmalnik" <kraj@servoyant.com> wrote:

I just used the upper(text) function on a database which is utf8 encoded and which has spanish text.

All of the regular characters were properly converted, except for characters which had accents.

 

 

pgsql-admin by date:

Previous
From: ALEXANDER JOSE
Date:
Subject: Postgresql for Windows 7
Next
From: Lou Picciano
Date:
Subject: pl/PHP build on PostgreSQL v9 beta?