Re: BLOBs or LONG/LONG RAW ? (student)

You can only have one LONG RAW in a row, so you should store the document as the long raw, and then the other attributes as varchar2's or whatever is appropriate. LONG RAW in Oracle really means Blob. I believe it will hold up to 2 gig.

On Fri, 23 Oct 1998 09:06:21 +0200, David Van den Brande <brandeda_at_se.bel.alcatel.be> wrote:

>Hi,
>
>For my thesis I have to make an Oracle7.3.3 database which will store
>documents (+/- 300kb per document) and there attributes ( version,
>author, category, format, keywords, ...).
>Should I use BLOBs or LONG / LONG ROWs ?
>
>Thanks in advance,
>David
Received on Fri Oct 23 1998 - 13:36:17 CDT