Project

General

Profile

Actions

Bug #78149

closed

Change field definition for caption and copyright in sys_file_metadata

Added by Thomas Hohn over 7 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
-
Target version:
Start date:
2016-10-05
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
7
PHP Version:
Tags:
Complexity:
no-brainer
Is Regression:
No
Sprint Focus:

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


Related issues 2 (0 open2 closed)

Related to TYPO3 Core - Bug #77970: Indexing external files with path longer than 255 charsClosed2016-09-16

Actions
Related to TYPO3 Core - Feature #52719: Advanced metadata for FileClosed2013-10-12

Actions
Actions

Also available in: Atom PDF