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

[ries van Twisk]

On Dec 6, 2007, at 7:42 AM, Malte Jansen wrote:

> Moreno Feltscher schrieb:
>>> It seems that Mysql's mediumtext gets mapped to varchar2(4000),  
>>> but that
>>> shouldn't happen because the former can hold much more data.
>> Yes, that's true. LONG would be a possible solution, but I don't know
>> what happens if i change this.. Therefore it would be nice, if there
>> is anyone who tried this already. Otherwise I will test it on my
>> testing-system.

On PostgreSQL this can be mapped to text, can this also be true for  
oracle?
Basically what I did is changed ALL varchars to text.


>>
>>
>>>> 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?
>> All the open bug reports are non-answered... I don't think this is a
>> positive point to all the people thinking about implementing TYPO3
>> with Oracle..
> I think the problem is, that you have to pay for oracle. So most devs
> are only using MySQL, because it's free. So nobody can really check  
> it.

The problem is that quite a number of people would love
to run it on Oracle (or other RDBM's),
however there are way to many obstacles to run TYPO3 on any
other DB then MySQL. Problems with upgrading + problems with stability.

>
>
>> At all my system runs quite well, I have some problems with  
>> extensions
>> which don't use the TYPO3 database syntax but I fix them manually.
>> If I can solve this problem with the long strings quickly I will be
>> able to set my system to a live-state in about a week.
>>
>>
>> Moreno
>
> You could make a small extension which is walking through $TCA and
> checks, which datatype is used, if it's to small, you can alter it. ;)
>
> Cheers,
>
> Malte
> _______________________________________________
> TYPO3-dev mailing list
> TYPO3-dev at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev

--
Ries van Twisk
Freelance TYPO3 Developer
email: ries at vantwisk.nl
web:   http://www.rvantwisk.nl/
skype: callto://r.vantwisk
Phone: + 1 810-476-4193