Re: Newbie's Question - RAW Vs LONG RAW

From: HansF <News.Hans_at_telus.net>
Date: Mon, 13 Jun 2005 13:46:30 GMT
Message-Id: <pan.2005.06.13.13.49.30.19495@telus.net>

On Mon, 13 Jun 2005 14:51:17 +0800, mon interested us by writing:

> What is the difference between LONG RAW and RAW? It seems that both
> represents unstructured large binary data.

RAW - binary, limited to 2000 bytes.
Long RAW - binary up to 2 GB

From Oracle's SQL Reference manual, chapter 1, which describes all datatypes:

Note:

Oracle Corporation strongly recommends that you convert LONG columns to LOB columns as soon as possible. Creation of new LONG columns is scheduled for desupport.

LOB columns are subject to far fewer restrictions than LONG columns. Further, LOB functionality is enhanced in every release, whereas LONG functionality has been static for several releases. See the modify_col_properties clause of ALTER TABLE and TO_LOB for more information on converting LONG columns to LOB.

That document is available at http://docs.oracle.com

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***

Received on Mon Jun 13 2005 - 08:46:30 CDT