Home » Server Options » Text & interMedia » Searching for text in BLOB field
Searching for text in BLOB field [message #75931] Tue, 19 March 2002 09:54 Go to next message
AL
Messages: 24
Registered: October 2000
Junior Member
Hello,

I have a BLOB field that holds both binary (image)
data and plain text. Is there a way to index
this column using IMedia and do text searches
on it?

I tried creating an intermedia index on the
table, and then do a simple text search like
contains ('abc') >0 but no results came back.
Do i have to convert 'abc' to binary maybe?

Thanks
AL.
Re: Searching for text in BLOB field [message #75950 is a reply to message #75931] Tue, 14 May 2002 13:48 Go to previous messageGo to next message
HK
Messages: 2
Registered: April 2002
Junior Member
Hi !

Did you get this problem worked out. I have the same requirement while working on one of my application.

Please let me know if you have any workarounds.

- hk
Re: Searching for text in BLOB field [message #75953 is a reply to message #75950] Wed, 15 May 2002 22:09 Go to previous message
AL
Messages: 24
Registered: October 2000
Junior Member
This problem exists only on LINUX installations
of 8.1.7 that have patch 8.1.7.2 patch installed.
All others (NT, Solaris, etc) should be fine.
The fix is a patch of Intermedia by Oracle.
Previous Topic: Re: Problem installing Oracle comUnity
Next Topic: link error on ctxhx Ora 92010/RedHat7.3
Goto Forum:
  


Current Time: Thu Mar 28 05:04:19 CDT 2024