#78149Change field definition for caption and copyright in sys_file_metadata
Description
In the moderne publishing business and probably in other areas the
definition of caption (https://github.com/TYPO3/TYPO3.CMS/blob/master/typo3/sysext/filemetadata/ext_tables.sql#L8) and copyright (https://github.com/TYPO3/TYPO3.CMS/blob/master/typo3/sysext/filemetadata/ext_tables.sql#L14) as varchar(255) is to small.
In addition filemeta data from for instance iStock and other image providers
are often langer than 255 characters.
We propose to change the definition to a text instead since this extension
is also required when using Solr as search engine.
CREATE TABLE sys_file_metadata (
...
caption text,
...
copyright text,
...
);
With kind regards
Thomas