Re: Searching CLOBS case insensitive

From: Pablo Sanchez <pablo_at_dev.null>
Date: Wed, 18 Dec 2002 21:26:59 GMT
Message-ID: <Xns92E892FD6AB37pingottpingottbah@209.242.64.107>

Petri33_at_hotmail.com (Petri) wrote in
news:b4803f2d.0212181312.2dcc4fde_at_posting.google.com:

> I am trying to search a CLOB field case insensitively. I am
> currently using dbms_lob.instr() but this function is case
> sensitive. Does anyone know how to search case insensitively?

Unless you plan on having very few CLOB searches, you might want to instead use the Intermedia/Context cartridge to do this activity.

-- 
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com

Received on Wed Dec 18 2002 - 15:26:59 CST