Search inside a long raw field

From: Hans Börjesson <hansb_at_REMvendimo.REM.com>
Date: Wed, 17 Sep 2003 12:01:57 +0200
Message-ID: <bk9b4n$6v6$1@yggdrasil.utfors.se>

Hi!

We have an application, which uses RDO to access Oracle database (Microsoft ODBC for Oracle). The user is able to save free text like a note which we today store in a varchar2 field. This is limited to 4000 characters. We would like to increase this but we are limited on the datatypes we can use because we are using Microsoft ODBC driver (unfortunatley we cannot migrate to Oracle's driver for other reasons and to migrate to ADO or something similar is not possible at the time being). I guess the only option we have is the long raw datatype?

Will it be possible to do a search in a long raw field (from a sp maybe)? I guess (if it is possible) the performance will be (s)low? Any other options (adding several varchar2 fields may be a workable solution but not a good one)?

BTW We should support Oracle 8.1.7 and higher.

Regards
/Hans Received on Wed Sep 17 2003 - 05:01:57 CDT