On Mon, Jun 6, 2011 at 2:24 PM, Heine Ferreira <heine.ferreira@xxxxxxxxx> 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? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
