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

[Dmitry Dulepov]

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

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.

-- 
Dmitry Dulepov
TYPO3 core&security teams member
Twitter: http://twitter.com/dmitryd
Read more @ http://dmitry-dulepov.com/