case insensitive sorting & searching in oracle 10g

From: David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: case insensitive sorting & searching in oracle 10g
Date: 2004-08-05 09:04:20
Message-ID: 4111F814.3020504@zara.6.isreserved.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

--
dave

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pierre-Frédéric Caillaud 2004-08-05 09:52:58 Re: case insensitive sorting & searching in oracle 10g
Previous Message Mark Cave-Ayland 2004-08-05 07:20:28 Re: Recursive PLPGSQL function?