BLOB vs LONG RAW

From: <jpickup_at_my-deja.com>
Date: Fri, 24 Nov 2000 13:18:01 GMT
Message-ID: <8vlpq8$v83$1@nnrp1.deja.com>

When using an Oracle 8i database, which datatype should I be using for storing binary data? In the past I've always used LONG RAW but see that there is now a BLOB type.

I've written some code to use the BLOB and it was rather different (the LOB Locator stuff is RETURNING keyword is pretty weird). At this stage LONG RAW is looking better as it seems more straight-forward to use.

A quick summary of pros and cons of the two types would be great...

Thanks,
John.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 24 2000 - 07:18:01 CST