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

[Martin Kutschker]

Xavier Perseguers schrieb:
> 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.

Masi