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

[Xavier Perseguers]

Hi Georg,

>> Xavier Perseguers wrote:
>>>> Do I understand the problem correctly:
>>>> - BLOB/CLOB cannot be used with LIKE
>>>> - TEXT cannot be mapped automatically to VARCHAR(4000) because TEXT
>>>> fields
>>>> can use more than 4000 characters
>>>
>>> yes.
>>
>> Than we have no choice but use varchar(4000) :( It is so unclean... I
>> guess
>> we need a comment in ext_tables.sql saying why it is 4000. Otherwise
>> there
>> will be someone who will try to change it to another value.
>>
>
> If thats the case, then this is not a DAM-issue but rather a T3-DBAL
> Issue and should be solved as such (core or dbal group);

Please reread the thread, it is not a problem of Core or DBAL themselves.

Regards
Xavier Perseguers