[TYPO3-dev] More than 4000 characters in a CLOB

[Xavier Perseguers]

Hi,

>> Was someone successful in storing more than 4000 characters in an 
>> Oracle CLOB? Because having an UPDATE or INSERT statement in TYPO3 is 
>> not carefully handled by AdoDB when having a CLOB field.
>>
>> For instance trying to store a "big" datastructure from TemplaVoilà 
>> fails or trying to store a "long" text in a CE fails too.
> 
> The used "image" fields in SQL Server.
> Maybe this helps?

The problem is not the CLOB datatype, it's correct and can handle up to 
4GB of data, but it can not be used directly with more than 4000 
characters in INSERT or UPDATE statements:

INSERT INTO table (clob-column) VALUES ('some really long text with more 
than 4000 characters')

It's OK for MySQL with for instance a TEXT datatype column but the text 
cannot be more than 4000 characters in such statement when dealing with 
Oracle.

Other resource with driver oci8 and PHP [1].

However this seems not to be handled by ADOdb.

[1] 
http://www.oracle.com/technology/pub/articles/oracle_php_cookbook/fuecks_lobs.html

-- 
Xavier Perseguers
DBAL-Member

http://xavier.perseguers.ch/en/tutorials/typo3.html