Help me please I need search some text in CLOB field and this search must be case-insensitive. How can i do? Thanks
What database server are you using?
Have you tried doing a LIKE on the column in question?
IE : SELECT x FROM y WHERE x LIKE '%search text%'
As for case insensitive this is up to your database server configuration.
I use Oracle 8i - PHP 4 - Apache 1.13. I 've tried to use:
INSTR(UPPER(DBMS_LOB.SUBSTR(SEZIONE_ARTICOLO.TESTO,4000,1)),'".strtoupper($testo)."')> 0
but max dimension for output is 4000 character and some times i have 20.000 char
I don't know oracle, but my guess is that is the wrong way to do it.
Ok Thanks
