case sensitivity?

From: Heine Ferreira <heine(dot)ferreira(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: case sensitivity?
Date: 2011-06-06 20:24:45
Message-ID: BANLkTikbgqZR6r0K9haCyiTfAFt60ud5cw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2011-06-06 20:29:04 Re: case sensitivity?
Previous Message Chris Curvey 2011-06-06 20:21:55 Re: newbie question