[thesite] searching an oracle LONG column

Dean Mah dmah at shaw.ca
Mon Feb 25 14:25:01 CST 2002


Sure, if 2000 characters is good enough.  The other option is to write
the function so that it takes the search string as well and iterates
through the LONG looking for matches.

Dean


rudy writes:

> found this while researching something else
>
> "You are limited to searching the first 2000 characters of the long
> column, but this is often good enough."
>
> http://www.arrowsent.com/oratip/tip23.htm
>
> can we use this to search articles by more than title and synopsis?



More information about the thesite mailing list