Go with the CLOB. As you stated, you can have more than one CLOB defined in
a table. Also, you can pull out data randomly instead of sequentially. Plus,
the data can reside inline (for less than 4KB) or out of line for bigger

The key to making it work is using the DBMS_LOB package. See the Oracle
documentation on this to get an idea, then ask a more specific question.

If you're a member of technet, you'll be able to read this:

If not, join up ASAP! (It's free).

Good luck,


> From: "Andreas Eckhoff" <[EMAIL PROTECTED]>
> Date: Tue, 31 Jul 2001 15:09:52 +0200
> Subject: [PHP-DB] long or LOBs in oracle ???
> Hi everybody,
> I have a little question. What is the best datatype to put large character
> data into (more than 5.000-20.000 letters). Maybe a CLOB or a long ? I am
> quiet new to oracle so I don't know so much about the LOBs and how Oracle
> handles it. On thing is, that I have to use more than one large field in one
> table, this means that I cannot use the long type, because only one is
> allowed, right. OK Then I think there is only a LOB Type (maybe the CLOB is
> the best for my stuff).
> I tried it, but I cannot put the data in the normal way into the field, like I
> am used to with MYSQL longtext type.
> How can I put LOB data into the DB via PHP or is there an other method to put
> large character data into the DB, can anybody help me
> thanx in advance,
> Andy

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to