Daniel Morgan wrote:
> Michael Hill wrote:
>
>> 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?
>>
>> Mike
>>
>
> Strictly speakig no because Oracle would never limit itself to a
> brain-dead architecture like MS Access.
>
> You don't mention version but for years now VARCHAR2 fields have held
> 4000 bytes (not characters Mike) and CLOB fields will hold up to 4 GB.
>
> Either of these can be used to hold text information and either will
> greatly outperform MS Access capabilities.
>
And asof 9iR2 4000 Characters. UTF and all.
--
Regards,
Frank van Bortel
Received on Wed Jan 14 2004 - 14:11:52 CST
