Sv: cASE sensitive search via ODBC ???

From: Freddy Kristiansen <fk_at_dsinet.dk>
Date: Fri, 28 Jan 2000 19:49:23 +0100
Message-ID: <Gxlk4.354$067.1201@news.get2net.dk>

> in Oracle 8i it is possible to create function Indexes which means, an
> index on a text column with upper(column_name). With this option you can
> create an index where all words are in uppercase. if you select in
> uppercase there should be no problem. In Oracle 7.x.x you may write a
> trigger which fills a column in uppercase. Put an index on that column
> and use this column for your select. Another possibility is ORACLE
> Context option, which can retrieve unstructured text from a column. With
> that option you can search with any case.

The Oracle 7 way was exactly the way which i used on Oracle 7.x - but the Oracle 8 way looks very interresting.

But how does one do it ?

I tried :

CREATE INDEX TEST_NAME ON TEST (UPPER(NAME)); This gives an error !

Freddy Received on Fri Jan 28 2000 - 12:49:23 CST