Re: create index with lowercase

From: Justin Cave <jocave_at_yahoo.com>
Date: 4 Nov 2002 13:30:39 -0800
Message-ID: <233b7a65.0211041330.6952cba9@posting.google.com>

"J rg Schneider" <oracle_news.3.joesch_at_spamgourmet.com> wrote in message news:<aq61jl$5mj$1_at_newsreader2.netcologne.de>...
> Hello together,
>
> thank you for your solutions but both solutions are no practicable. The
> first one makes the database to big and the second solution ist not
> felexible.

The only other solution would be to modify the existing entries to all be lowercase, add a trigger that ensures all future rows are lowercase, and write a procedure that "pretty prints" the data in mixed case. The feasibility of this approach depends significantly on whether you can come up with a procedure that puts the capitalization back in correctly (or correctly enough).

Justin Cave Received on Mon Nov 04 2002 - 15:30:39 CST