[thesite] meta description

Dean Mah dmah at shaw.ca
Mon Jan 21 21:06:05 CST 2002


Correct.  You can't do functions on LONG datatypes.  One of the many
restrictions.

Dean


Warden, Matt writes:

> >can you force it to a case-insensitive search by wrapping the column
> >reference with a Lower() function?  for example:
> >
> >DBMS_LOB.INSTR(Lower(column), '#LCase(search_string)#') <> 0
> 
> no, i tried that a few days ago when i was playing around with
> dbms_lob on the test db. it gives an invalid type message of some
> sort. I guess you can't use LOWER() on that type of field.




More information about the thesite mailing list