Re: case insensitive sorting & searching in oracle 10g

Hi,

I don't like the solution. "Select ... order by ..." should be self-contained
and not dependant of some settings. Case-insensitive sort should be specified
in the order-by-clause like "select ... order by lower(a)".


Tommi

Am Donnerstag, 5. August 2004 11:04 schrieb David Garamond:
> in oracle 10g, you can issue:
>
>   ALTER SESSION SET NLS_COMP = ansi;
>   ALTER SESSION SET NLS_SORT = binary_ci;
>
> do you think this is an elegant solution for case insensitive sorting &
> searching? is there interest in seeing this in postgres?