Re: Select <-> Case Insensitive

Devrim GUNDUZ wrote:
> The query
>
> SELECT * from mytable order by lower(description);
>
> could solve your problem.

I seem to recall (From C/C++ at least) that you should upcase text
for case insensitive comparisons, as with some languages there is no
well defined upper->lower conversion, but there is always a
unique lower->upper transformation.

Is this correct for (Postgres)SQL locale support as well?

-Mark

--
Mark Rae Tel: +44(0)20 7074 4648
Inpharmatica Fax: +44(0)20 7074 4700
m(dot)rae(at)inpharmatica(dot)co(dot)uk http://www.inpharmatica.co.uk/