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

[Martin Kutschker]

Moreno Feltscher schrieb:
> 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.

It seems that Mysql's mediumtext gets mapped to varchar2(4000), but that 
shouldn't happen because the former can hold much more data.

> 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.

No "official" solutions or none at all. How do you fare with Oracle currently?

Masi