Re: [URGENT] Case unsensitive

Jinib <jinib_at_caramail.com> wrote:
> I must change the 'case sensitive' to 'case unsensitive' on an oracle
> database with Sun Solaris 8.

If you mean in the comparison of fields in the where part of a query, you can use something like

SELECT .... WHERE UPPER(field)=UPPER(...)

but this way, it will not use the indexes, so you are slowing down the query. If the table is not so big, it's Ok.

Davide Received on Fri Apr 12 2002 - 04:19:01 CDT