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

[Xavier Perseguers]

Hi,

Dmitry Dulepov wrote:
> Hi!
>
> Xavier Perseguers wrote:
>> 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...
>
> 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.

> I found pages on the Internet that say LIKE cannot be used with CLOB but
> this page suggests the opposite:
> http://www.dba-oracle.com/oracle_tips_like_sql_index.htm. Probably a mistake.

DBAL disallows LIKE on *LOB columns. My understanding is that you may 
"perhaps" search for it but you have to activate additional features 
such as full text indexing and it still is not efficient. And still, 
it's not sure all supported DBMS would have an option to allow this.

Xavier