DB design document

Christophe Guychard Christophe.Guychard@enst-bretagne.fr
Thu, 14 Dec 2000 10:06:25 +0100


> 
> You can't avoid having a limit on text fields, but you can make them
> very large.

> So we will use varchar fields, and make them fairly large. At your
> leisure, please review my schema and suggest maximum data sizes.

To store unlimited (un-indexed, but who needs to index comments?) text
objects, Oracle provides the CLOB (Character Large Objects).
I don't know for others, but at least DB2, SQL-Server support binary objects.

XtoF.