[TYPO3-dev] Problem with long strings in tt_content (Oracle)

[Moreno Feltscher]

Hi

I've got a big problem with my TYPO3-Installation in connection with
DBAL (I'm using Oracle 10g as database):
If you want to add a normal long text as content on a page, you get an
error: ORA-01704 String literal too long.

I found out, the problem occurs if the text is longer than 4000
characters (thats traceable, because the field "bodytext" in
"tt_content" has the type VARCHAR2(4000 byte)). The maximum capacity
of VARCHAR2 is 4000 bytes, in any case.

I think, most people need content which consists of more than 4000 characters..
My question is now: Would there be a problem, if I change the type of
"bodytext" to LONG (can store up to 2GB)?

This problem is also explained (but with no solution...) in this bugs:
http://bugs.typo3.org/view.php?id=5535
http://bugs.typo3.org/view.php?id=6164

Karsten, it would also be nice to hear something from your side about
this. In the past we had a lot of problems with DBAL and Oracle, but
no solutions for them.
Thanks

Greetings
Moreno Feltscher