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.rae@inpharmatica.co.uk                http://www.inpharmatica.co.uk/