long or LOBs in oracle ???

From: Date: Tue, 31 Jul 2001 13:09:52 +0000
Subject: long or LOBs in oracle ???
Groups: php.db 
Request: Send a blank email to php-db+get-10947@lists.php.net to get a copy of this message
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

« previous php.db (#10947) next »