Re: Memo Fields

From: Geoff Muldoon <gmuldoon_remove_this_bit__at_scu.edu.au>
Date: Tue, 13 Jan 2004 11:07:53 +1100
Message-ID: <MPG.1a6de1e35f418b759896f6@news.sbt.net.au>

hillmw_at_ram.lmtas.lmco.com says...
> I had a guy ask me about Memo Fields in Oracle.
>
> Remember Memo fields are the text files stored outside a Microsoft
> Access DB when the user creates a memo field in their DB.
>
> The question was: "Does Oracle have Memo Field".
> The answer I gave was that Oracle had a character field that goes up to
> 2000 charcters nad then everything else could be stored in a blob.
>
> Did I tell him correctly?

VARCHAR2 holds up to 4000 (not 2000) characters. If you're just storing text-only over that size, use CLOB (Character Large OBject) rather than BLOB (Binary Large OBject).

GM Received on Mon Jan 12 2004 - 18:07:53 CST