[TYPO3-dam-devel] RFC #12525: Adding metadata or category to a file duplicates the file in table tx_dam [DBAL]

[Dan Osipov]

I believe we've used 4000 characters for DBAL compatibility before. In 
that case, +1 by reading.

On 7/9/10 7:39 AM, Xavier Perseguers wrote:
> Hi,
>
>> I´m no databaseguru at all - so maybe this is a stupid question:
>>
>> I know that MySQL 5.1 will be able to handle varchar(4000) but: is
>> this true for 5.0 as well?
>> I think we have to keep in mind, that the majority of all
>> installations is run on MySql and the majority of those on 5.0...
>
> Well, the reference on mysql.com says:
>
> The length can be specified as a value from 0 to 255 before MySQL 5.0.3,
> and 0 to 65,535 in 5.0.3 and later versions.
>
> So yes, it handles 4000 characters. But I proposed the limit of Oracle.
> I'm quite sure even 4000 characters is way too much for any decent file
> organization in a website. Limiting this to 1000 should be large enough.
>
> Best
> Xavier

-- 
Dan Osipov
http://danosipov.com/blog