https://www.redmine.org/
https://www.redmine.org/favicon.ico?1679302129
2015-05-03T00:01:22Z
Redmine
Redmine - Patch #19742: RedmineInstall: MySQL: collation_database
https://www.redmine.org/issues/19742?journal_id=63489
2015-05-03T00:01:22Z
Toshi MARUYAMA
<ul><li><strong>Related to</strong> <i><a class="issue tracker-1 status-5 priority-4 priority-default closed" href="/issues/18866">Defect #18866</a>: MySQL: disappear after 4-Byte UTF-8</i> added</li></ul>
Redmine - Patch #19742: RedmineInstall: MySQL: collation_database
https://www.redmine.org/issues/19742?journal_id=63491
2015-05-03T00:04:18Z
Toshi MARUYAMA
<ul><li><strong>Subject</strong> changed from <i>RedmineInstall: Step 2 - implement a best practice for MySQL</i> to <i>RedmineInstall: MySQL: collation_database</i></li></ul>
Redmine - Patch #19742: RedmineInstall: MySQL: collation_database
https://www.redmine.org/issues/19742?journal_id=63492
2015-05-03T00:17:14Z
Toshi MARUYAMA
<ul></ul><p>I don't prefer defining utf8_general_ci or utf8_unicode_ci because many <strong>Japanese</strong> web site recommends <strong>utf8_general_ci</strong> because of unacceptable matching HIRAGANA (ひらがな) and KATAKANA (カタカナ).</p>
<p><a href="http://stackoverflow.com/questions/29916610/1273-unknown-collation-utf8mb4-unicode-ci-cpanel" class="external">MySQL 5.5.3</a> supports <strong>utf8mb4_unicode_ci</strong> and <strong>utf8mb4_general_ci</strong> (<a class="issue tracker-1 status-5 priority-4 priority-default closed" title="Defect: MySQL: disappear after 4-Byte UTF-8 (Closed)" href="https://www.redmine.org/issues/18866">#18866</a>).</p>
Redmine - Patch #19742: RedmineInstall: MySQL: collation_database
https://www.redmine.org/issues/19742?journal_id=64345
2015-06-22T03:48:32Z
Toshi MARUYAMA
<ul><li><strong>Related to</strong> <i><a class="issue tracker-1 status-5 priority-4 priority-default closed" href="/issues/10772">Defect #10772</a>: 4-byte utf-8 characters</i> added</li></ul>
Redmine - Patch #19742: RedmineInstall: MySQL: collation_database
https://www.redmine.org/issues/19742?journal_id=64350
2015-06-22T03:49:31Z
Toshi MARUYAMA
<ul><li><strong>Related to</strong> deleted (<i><a class="issue tracker-1 status-5 priority-4 priority-default closed" href="/issues/18866">Defect #18866</a>: MySQL: disappear after 4-Byte UTF-8</i>)</li></ul>
Redmine - Patch #19742: RedmineInstall: MySQL: collation_database
https://www.redmine.org/issues/19742?journal_id=64356
2015-06-22T03:54:56Z
Toshi MARUYAMA
<ul><li><strong>Related to</strong> deleted (<i><a class="issue tracker-1 status-5 priority-4 priority-default closed" href="/issues/10772">Defect #10772</a>: 4-byte utf-8 characters</i>)</li></ul>
Redmine - Patch #19742: RedmineInstall: MySQL: collation_database
https://www.redmine.org/issues/19742?journal_id=64359
2015-06-22T03:55:30Z
Toshi MARUYAMA
<ul><li><strong>Related to</strong> <i><a class="issue tracker-1 status-5 priority-4 priority-default closed" href="/issues/18866">Defect #18866</a>: MySQL: disappear after 4-Byte UTF-8</i> added</li></ul>
Redmine - Patch #19742: RedmineInstall: MySQL: collation_database
https://www.redmine.org/issues/19742?journal_id=64361
2015-06-22T03:55:48Z
Toshi MARUYAMA
<ul><li><strong>Related to</strong> <i><a class="issue tracker-1 status-1 priority-3 priority-lowest" href="/issues/20143">Defect #20143</a>: Mailhandler cannot handle 4-byte characters</i> added</li></ul>
Redmine - Patch #19742: RedmineInstall: MySQL: collation_database
https://www.redmine.org/issues/19742?journal_id=66917
2015-10-28T18:22:29Z
@ go2null
<ul></ul><p>How about the following change:</p>
<a name="FROM"></a>
<h3 > FROM <a href="#FROM" class="wiki-anchor">¶</a></h3>
<hr />
<a name="MySQL"></a>
<h4 >MySQL<a href="#MySQL" class="wiki-anchor">¶</a></h4>
<pre><code class="sql syntaxhl"><span class="k">CREATE</span> <span class="k">DATABASE</span> <span class="n">redmine</span> <span class="nb">CHARACTER</span> <span class="k">SET</span> <span class="n">utf8</span><span class="p">;</span>
<span class="k">CREATE</span> <span class="k">USER</span> <span class="s1">'redmine'</span><span class="o">@</span><span class="s1">'localhost'</span> <span class="n">IDENTIFIED</span> <span class="k">BY</span> <span class="s1">'my_password'</span><span class="p">;</span>
<span class="k">GRANT</span> <span class="k">ALL</span> <span class="k">PRIVILEGES</span> <span class="k">ON</span> <span class="n">redmine</span><span class="p">.</span><span class="o">*</span> <span class="k">TO</span> <span class="s1">'redmine'</span><span class="o">@</span><span class="s1">'localhost'</span><span class="p">;</span>
</code></pre>
<p>For versions of MySQL prior to 5.0.2 - skip the 'create user' step and instead:</p>
<pre><code class="sql syntaxhl"><span class="k">GRANT</span> <span class="k">ALL</span> <span class="k">PRIVILEGES</span> <span class="k">ON</span> <span class="n">redmine</span><span class="p">.</span><span class="o">*</span> <span class="k">TO</span> <span class="s1">'redmine'</span><span class="o">@</span><span class="s1">'localhost'</span> <span class="n">IDENTIFIED</span> <span class="k">BY</span> <span class="s1">'my_password'</span><span class="p">;</span>
</code></pre>
<a name="TO"></a>
<h3 > TO <a href="#TO" class="wiki-anchor">¶</a></h3>
<hr />
<a name="MySQL-2"></a>
<h4 >MySQL<a href="#MySQL-2" class="wiki-anchor">¶</a></h4>
<p>MySQL v5.5.3 and later<br /><pre><code class="sql syntaxhl"><span class="k">CREATE</span> <span class="k">DATABASE</span> <span class="n">redmine</span> <span class="nb">CHARACTER</span> <span class="k">SET</span> <span class="n">utf8mb4</span> <span class="k">COLLATE</span> <span class="n">utf8mb4_unicode_ci</span><span class="p">;</span>
<span class="k">CREATE</span> <span class="k">USER</span> <span class="s1">'redmine'</span><span class="o">@</span><span class="s1">'localhost'</span> <span class="n">IDENTIFIED</span> <span class="k">BY</span> <span class="s1">'my_password'</span><span class="p">;</span>
<span class="k">GRANT</span> <span class="k">ALL</span> <span class="k">PRIVILEGES</span> <span class="k">ON</span> <span class="n">redmine</span><span class="p">.</span><span class="o">*</span> <span class="k">TO</span> <span class="s1">'redmine'</span><span class="o">@</span><span class="s1">'localhost'</span><span class="p">;</span>
</code></pre></p>
<p>MySQL v5.0.2 and later<br /><pre><code class="sql syntaxhl"><span class="k">CREATE</span> <span class="k">DATABASE</span> <span class="n">redmine</span> <span class="nb">CHARACTER</span> <span class="k">SET</span> <span class="n">utf8</span> <span class="k">COLLATE</span> <span class="n">utf8_unicode_ci</span><span class="p">;</span>
<span class="k">CREATE</span> <span class="k">USER</span> <span class="s1">'redmine'</span><span class="o">@</span><span class="s1">'localhost'</span> <span class="n">IDENTIFIED</span> <span class="k">BY</span> <span class="s1">'my_password'</span><span class="p">;</span>
<span class="k">GRANT</span> <span class="k">ALL</span> <span class="k">PRIVILEGES</span> <span class="k">ON</span> <span class="n">redmine</span><span class="p">.</span><span class="o">*</span> <span class="k">TO</span> <span class="s1">'redmine'</span><span class="o">@</span><span class="s1">'localhost'</span><span class="p">;</span>
</code></pre></p>
<p>MySQL v5.0.1 and earlier<br /><pre><code class="sql syntaxhl"><span class="k">CREATE</span> <span class="k">DATABASE</span> <span class="n">redmine</span> <span class="nb">CHARACTER</span> <span class="k">SET</span> <span class="n">utf8</span> <span class="k">COLLATE</span> <span class="n">utf8_unicode_ci</span><span class="p">;</span>
<span class="k">GRANT</span> <span class="k">ALL</span> <span class="k">PRIVILEGES</span> <span class="k">ON</span> <span class="n">redmine</span><span class="p">.</span><span class="o">*</span> <span class="k">TO</span> <span class="s1">'redmine'</span><span class="o">@</span><span class="s1">'localhost'</span> <span class="n">IDENTIFIED</span> <span class="k">BY</span> <span class="s1">'my_password'</span><span class="p">;</span>
</code></pre></p>
<a name="OR"></a>
<h3 > OR <a href="#OR" class="wiki-anchor">¶</a></h3>
<hr />
<p>Add the following recommendation:</p>
<blockquote>
<p>It is recommended to use <code>CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci</code> for MySQL v5.5.3 and later, and <code>CHARACTER SET utf8 COLLATE utf8_unicode_ci</code> for earlier versions.</p>
</blockquote>
Redmine - Patch #19742: RedmineInstall: MySQL: collation_database
https://www.redmine.org/issues/19742?journal_id=67923
2015-12-14T10:45:41Z
Toshi MARUYAMA
<ul><li><strong>Related to</strong> <i><a class="issue tracker-1 status-5 priority-4 priority-default closed" href="/issues/21398">Defect #21398</a>: Mysql: 500 server error when submitting 4 bytes utf8 (to be saved in the 'notes' field)</i> added</li></ul>
Redmine - Patch #19742: RedmineInstall: MySQL: collation_database
https://www.redmine.org/issues/19742?journal_id=93181
2019-08-17T16:20:00Z
Marius BĂLTEANU
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Closed</i></li></ul><p><a class="wiki-page" href="https://www.redmine.org/projects/redmine/wiki/RedmineInstall">RedmineInstall</a> was updated in the mean time.</p>
Redmine - Patch #19742: RedmineInstall: MySQL: collation_database
https://www.redmine.org/issues/19742?journal_id=93182
2019-08-17T16:20:30Z
Marius 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>