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.

Answer 1

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