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

[Malte Jansen]

Dmitry Dulepov [typo3] schrieb:
> Malte Jansen wrote:
>> To find all columns which have the wrong type, you could check it 
>> easily with the $TCA.
> 
> TCA just says "text". But it mapsdifferently for different database. It 
> will be VARCHAR2 for Oracle and MEDIUMTEXT for MySQL. It appears that 
> VARCHAR2 is not the best choice.
> 

You but you can get the type with "SHOW FULL COLUMNS".

Or you could just walk through the db and check it.