Oracle Equivalent of MySQL's TEXT type


Question

Does Oracle have an equivalent column type to MySQL's TEXT type?

If not, how are larger blobs of text typically stored? BLOB, varchar(32767)? It's Oracle 10 being accessed via PHP, if it matters. Historical context is more than welcome.

1
16
7/24/2009 9:23:33 PM

Accepted Answer

Oracle has BLOB, CLOB and NCLOB for storing binary, character and unicode character data types. You can also specify the LOB storage area which allows a DBA to fine tune the storage if necessary (i.e. putting the LOB data on separate disks)

This page gives a bit more info: http://www.dba-oracle.com/t_blob.htm

13
7/24/2009 9:29:03 PM

I think you probably want the CLOB datatype.


Licensed under: CC-BY-SA with attribution
Not affiliated with: Stack Overflow
Icon