Thread: case sensitivity?

Hi

I posted a similar question before. I was told that Postgres is always case sensitive.
I was actually referring to text data not identifiers.
I mean char and varchar fields.
I basicically want to avoid using upper in comparisons.
With some databases you can use a utf8 characterset and a unicode or win1252 coallation.
Has anyone tried this?
Do you know if this will work?

Thanks

H.F.

On Mon, Jun 6, 2011 at 2:24 PM, Heine Ferreira <heine.ferreira@gmail.com> wrote:
> Hi
>
> I posted a similar question before. I was told that Postgres is always case
> sensitive.
> I was actually referring to text data not identifiers.
> I mean char and varchar fields.
> I basicically want to avoid using upper in comparisons.
> With some databases you can use a utf8 characterset and a unicode or win1252
> coallation.
> Has anyone tried this?
> Do you know if this will work?

Maybe the citext type would do what you want?

On Mon, Jun 06, 2011 at 10:24:45PM +0200, Heine Ferreira wrote:

> I basicically want to avoid using upper in comparisons.
> Has anyone tried this?
> Do you know if this will work?

There's a contrib module that will allow you to do this.  See the
citext datatype.

A

--
Andrew Sullivan
ajs@crankycanuck.ca