Re: Long Strings & Oracle

From: <kal121_at_my-deja.com>
Date: Mon, 02 Aug 1999 13:52:41 GMT
Message-ID: <7o47r6$k4t$1@nnrp1.deja.com>

Oracle 8 has varchar2(4000)
or you can store one line at a time,
each line being a separate row.

In article <7o41rm$6sa_at_news-central.tiac.net>, "Hank Riehl" <hankr_at_skillview.com> wrote:
> We'd like to add the capability for our application to store an
> employee's resume and permit management to run keyword search queries
> against the resume library using LIKE or CONTAINS in the WHERE clause.
>
> Oracle 7.x seems to have a 2000 character limitation on the VARCHAR2
> datatype which is too few characters. The Oracle LONG datatype does
not
> permit references to it in a SQL WHERE clause.
>
> Any ideas on how to achieve this functionality? I can't believe that
> Oracle's character-handling is so restrictive.
>
> Thanks... Hank Riehl
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Aug 02 1999 - 08:52:41 CDT