Re: Like Operator with CLOB datatype

From: Steve Howard <stevedhoward_at_gmail.com>
Date: 21 Nov 2006 06:18:02 -0800
Message-ID: <1164118682.164875.299630@k70g2000cwa.googlegroups.com>

bala wrote:

> Think changing the Datatype would be the safest approach till the user
> tries to enter more than 2000 characters.
>
> Thanx again
>
> Regards
> Bala

IIRC, if you *link* a table in Access to Oracle with a VARCHAR2(4000) column, Access will map it as a MEMO datatype, which means you shouldn't be subject to a 2000 character limit (4000, of course, though). I may be mis-remembering, though.

Regards,

Steve Received on Tue Nov 21 2006 - 08:18:02 CST