Daniel Morgan wrote:
>
> Frank van Bortel wrote:
>
> > 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.
>
> 4000 characters even if they characters are 3 bytes each? Are you sure?
Oracle has been very careful to discriminate betwwen 'character' and
'byte' in their docco. From the SQL Reference manual for 9iR2, datatype
'VARCHAR2' is 4000 bytes, datatype 'NVARCHAR2' is 4000 [unicode]
characters and that means 'up to 16,000 bytes'.
Received on Wed Jan 14 2004 - 20:07:35 CST
