[TYPO3-dev] Problem with long strings in tt_content (Oracle)
Moreno Feltscher
moreno.feltscher at gmail.com
Tue Dec 11 10:22:37 CET 2007
Hi again
I now changed the type of the column "bodytext" in "tt_content" from
VARCHAR2 to CLOB.
This ended in the fact I cannot add content (all types of) anymore.
The hole INSERT isn't working anymore for this records.
I found out the oci8 with PHP handles CLOB-inserts in a other way then
normal inserts (http://ch2.php.net/manual/en/ref.oci8.php ->
"Example#3 Inserting data into a CLOB column").
So I started searching a solution over DBAL and found this:
http://typo3.org/fileadmin/typo3api-4.0.0/de/d07/classt3lib__DB.html#a67725ef8af34426893025b9a8bd4326
"Creates and executes an INSERT SQL-statement for $table from the
array with field/value pairs $fields_values. Using this function
specifically allows us to handle BLOB and CLOB fields depending on DB
Usage count/core: 47"
Very interesting.. So, does anybody here know how does this work? Does
DBAL can find out which column type is used or do I have to configure
this?
Moreno
More information about the TYPO3-dev
mailing list