Обсуждение: 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.
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