Re: Case Insensitive Queries - Mailing list pgsql-sql

From Tom Lane
Subject Re: Case Insensitive Queries
Date
Msg-id 21545.991232634@sss.pgh.pa.us
Whole thread Raw
In response to Re: Case Insensitive Queries  ("tjk@tksoft.com" <tjk@tksoft.com>)
Responses Re: Case Insensitive Queries
List pgsql-sql
"tjk@tksoft.com" <tjk@tksoft.com> writes:
> If upper() and lower() operate on characters in 8859-1 and other character
> sets when the appropriate locale is set, then a difference in the behavior
> of upper() and lower() would seem like a bug.

Au contraire ... upper() and lower() are not symmetric operations in
quite a few non-English locales.  I'll let those who regularly work with
them give specific details, but handling of accents, German esstet (sp?),
etc are the gotchas that I recall.
        regards, tom lane


pgsql-sql by date:

Previous
From: DI Hasenöhrl
Date:
Subject: ERROR: Class '37632' not found
Next
From: Tom Lane
Date:
Subject: Re: ERROR: Class '37632' not found