https://www.redmine.org/https://www.redmine.org/favicon.ico?16793021292016-02-29T11:50:05ZRedmineRedmine - Defect #22119: Error: Data too long for column 'notes' when copy paste pictureshttps://www.redmine.org/issues/22119?journal_id=694802016-02-29T11:50:05ZGo MAEDA
<ul></ul><p>What is the size of the text and what database do you use?<br />I guess the text is longer than 64KB and the database is MySQL.</p> Redmine - Defect #22119: Error: Data too long for column 'notes' when copy paste pictureshttps://www.redmine.org/issues/22119?journal_id=696592016-03-14T13:15:24ZThomas Koch
<ul></ul><p>Yes, Mysql (as the error shows as well)<br />I do not know the size of that image, but I guess it will be more the 64kB.</p> Redmine - Defect #22119: Error: Data too long for column 'notes' when copy paste pictureshttps://www.redmine.org/issues/22119?journal_id=696722016-03-15T02:55:15ZGo MAEDA
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Closed</i></li><li><strong>Resolution</strong> set to <i>Duplicate</i></li></ul><p>The size of issue.descpiption and journal.notes are limited to 64KB on MySQL for now.<br />Closing this issue as a duplicate of <a class="issue tracker-2 status-5 priority-4 priority-default closed" title="Feature: Consider increasing the size limit of description and note columns for tickets (Closed)" href="https://www.redmine.org/issues/19869">#19869</a>.</p> Redmine - Defect #22119: Error: Data too long for column 'notes' when copy paste pictureshttps://www.redmine.org/issues/22119?journal_id=696732016-03-15T02:55:33ZGo MAEDA
<ul><li><strong>Is duplicate of</strong> <i><a class="issue tracker-2 status-5 priority-4 priority-default closed" href="/issues/19869">Feature #19869</a>: Consider increasing the size limit of description and note columns for tickets</i> added</li></ul> Redmine - Defect #22119: Error: Data too long for column 'notes' when copy paste pictureshttps://www.redmine.org/issues/22119?journal_id=697132016-03-16T10:04:32ZThomas Koch
<ul></ul><p>Converting the whole database from utf8 to utf8mb4 solve this issue! (see: <a class="issue tracker-1 status-5 priority-4 priority-default closed" title="Defect: Mysql: 500 server error when submitting 4 bytes utf8 (to be saved in the 'notes' field) (Closed)" href="https://www.redmine.org/issues/21398">#21398</a>)</p>
<p>The data type of all text fields got automatically changed from text to mediumtext, which can hold up to 16MB!</p>
<p><strong>Redmine should catch this exception</strong> and give more details. Same here: <a class="issue tracker-1 status-5 priority-4 priority-default closed" title="Defect: Mysql: 500 server error when submitting 4 bytes utf8 (to be saved in the 'notes' field) (Closed)" href="https://www.redmine.org/issues/21398">#21398</a>!</p> Redmine - Defect #22119: Error: Data too long for column 'notes' when copy paste pictureshttps://www.redmine.org/issues/22119?journal_id=931742019-08-17T16:15:14ZMarius BÄ‚LTEANU
<ul><li><strong>Related to</strong> <i><a class="issue tracker-2 status-5 priority-4 priority-default closed" href="/issues/31921">Feature #31921</a>: Changes to properly support 4 byte characters (emoji) when database is MySQL</i> added</li></ul>