Re: Easy data types question - free format text

Simon Rawson wrote:
>
> Hi,
>
> I'm converting an Access database into Oracle and need advice on suitable
> data types to replace a memo field.
>
> The maximum length I expect to see is about 4000 characters, however it is
> free format text so I have to code it a little defensively.
>
> I understand that the long type would be most suitable, however this is an
> obsolete type according to the doco.
>
> Can anyone help with a recommendation and of so are there limitations on the
> use of the type recommended, particularly when using text searches in a
> select statement using like clauses etc.
>
> Thanks in advance,
> Simon Rawson

VARCHAR2 or CLOB.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse