[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.
>>> Maybe TEXT is mapped to VARCHAR(4000) instead of CLOB. Did you check the
>>> TABLE definitions?
>> Yes, it is mapped to CLOB, that's OK but as I said, more than 4000
>> characters *cannot* be sent directly with an UPDATE/INSERT statement.
> 
> I know, but ADOdb knows that too.  For PostgreSQL this works alright and
> PostgreSQL also requires you to store/retrieve LOBs with special means.

Great! But then the question is why it does not work for Oracle :-)

-- 
Xavier Perseguers
DBAL-Member

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