Bytes in Oracle database

[EMW]

What do I use to load a amount of bytes into the Oracle database?

I've to choose from:

CHAR
VARCHAR2
NCHAR
NVARCHAR
NUMBER (ok I know it isn't this one)
DATE (ok I know it isn't this one)
LONG (ok I know it isn't this one)
RAW
LONGRAW
ROWID
BLOB
CLOB
NCLOB
BFILE
UROWID
FLOAT (ok I know it isn't this one)
XMLTYPE (ok I know it isn't this one)


rg,
Eric

 

[Miha Markic [MVP C#]]

Hi,

From docs:
RAW <= 2000 bytes
LONG RAW <=2^31 - 1 (2,147,483,647) bytes
BLOB up to 4 gigabytes

Pick one of these.

 

[Paul Clement]

¤ What do I use to load a amount of bytes into the Oracle database?
¤
¤ I've to choose from:
¤
¤ CHAR
¤ VARCHAR2
¤ NCHAR
¤ NVARCHAR
¤ NUMBER (ok I know it isn't this one)
¤ DATE (ok I know it isn't this one)
¤ LONG (ok I know it isn't this one)
¤ RAW
¤ LONGRAW
¤ ROWID
¤ BLOB
¤ CLOB
¤ NCLOB
¤ BFILE
¤ UROWID
¤ FLOAT (ok I know it isn't this one)
¤ XMLTYPE (ok I know it isn't this one)

Depends upon the type of data and size. VARCHAR2 is commonly used (up to 4,000 bytes), but for a
large amount of text data you would use a CLOB.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)