Other Oracle database topics - Newbie's Question

Author

Newbie's Question - RAW Vs LONG RAW

mon

2005-06-13, 3:23 am

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

Michel Cadot

2005-06-13, 3:23 am

"mon" <mon@less.com.au> a écrit dans le message de news:42ad2ced_1@rain
.i-cable.com...
| What is the difference between LONG RAW and RAW? It seems that both
| represents unstructured large binary data.
|
|

The same than those between LONG and VARCHAR2 but no more use LONG RAW use BLOB.

See SQL Reference, section Datatypes:
http://download-west.oracle.com/doc...nts2a.htm#45443

Regards
Michel Cadot

HansF

2005-06-13, 9:23 am

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_propertie
s 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 ***

Sponsored Links