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

[Xavier Perseguers]

Hi,

> Doesn't that mean that mapping is incorrect? I do not know Oracle at all
> but many extension use "text" as field type. Can't (shouldn't?) it be
> solved on DBAL level? DBAL purpose is to provide exactly this: change
> queries to be compatible with a corresponding database. But with this patch
> we create an unclean and undocumented dependency on DBAL.
>
> Xavier, could you explain this, please? Is there a problem for DBAL to map
> "text" in some other way so that extensions do not need to use varchar(4000)?

text can be huge. As such DBAL maps it to some "blob" type, which is 
correct but cannot be used to perform LIKE queries on it anymore...

Xavier