https://www.redmine.org/https://www.redmine.org/favicon.ico?16793021292021-02-26T17:57:43ZRedmineRedmine - Defect #34810: SQL Error with UTF8 character greater or equalshttps://www.redmine.org/issues/34810?journal_id=1011102021-02-26T17:57:43ZFlorent H.
<ul></ul><p>To make it work quickly, I just replaced the character by >=, this is not a problem for my usage.</p> Redmine - Defect #34810: SQL Error with UTF8 character greater or equalshttps://www.redmine.org/issues/34810?journal_id=1011382021-02-28T16:46:21ZMarius BÄ‚LTEANU
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Needs feedback</i></li></ul><p>What kind of database encoding are you using?</p>
<p>You can use the following queries to retrieve this:</p>
<p>1. MySQL config:<br /><pre><code class="sql syntaxhl"><span class="k">SHOW</span> <span class="n">VARIABLES</span> <span class="k">WHERE</span> <span class="n">Variable_name</span> <span class="k">LIKE</span> <span class="s1">'character</span><span class="se">\_</span><span class="s1">set</span><span class="se">\_</span><span class="s1">%'</span> <span class="k">OR</span> <span class="n">Variable_name</span> <span class="k">LIKE</span> <span class="s1">'collation%'</span><span class="p">;</span>
</code></pre></p>
<p>2. Redmine database:<br /><pre><code class="sql syntaxhl"><span class="k">SELECT</span> <span class="n">default_character_set_name</span> <span class="k">FROM</span> <span class="n">information_schema</span><span class="p">.</span><span class="n">SCHEMATA</span> <span class="k">WHERE</span> <span class="k">schema_name</span> <span class="o">=</span> <span class="nv">"<redmine_database_name>"</span><span class="p">;</span>
</code></pre></p> Redmine - Defect #34810: SQL Error with UTF8 character greater or equalshttps://www.redmine.org/issues/34810?journal_id=1021172021-04-19T22:43:47ZMarius BÄ‚LTEANU
<ul><li><strong>Status</strong> changed from <i>Needs feedback</i> to <i>Closed</i></li><li><strong>Resolution</strong> set to <i>Invalid</i></li></ul><p>Please reopen with the required information.</p> Redmine - Defect #34810: SQL Error with UTF8 character greater or equalshttps://www.redmine.org/issues/34810?journal_id=1021292021-04-20T06:08:03ZFlorent H.
<ul><li><strong>Status</strong> changed from <i>Closed</i> to <i>Reopened</i></li></ul><p>Sorry, I missed the notification email.</p>
<pre>
MariaDB [(none)]> SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';
+--------------------------+--------------------+
| Variable_name | Value |
+--------------------------+--------------------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8 |
| collation_connection | utf8mb4_general_ci |
| collation_database | utf8mb4_general_ci |
| collation_server | utf8mb4_general_ci |
+--------------------------+--------------------+
10 rows in set (0.128 sec)
</pre>
<pre>
MariaDB [(none)]> SELECT default_character_set_name FROM information_schema.SCHEMATA WHERE schema_name = "redmine";
+----------------------------+
| default_character_set_name |
+----------------------------+
| utf8mb4 |
+----------------------------+
1 row in set (0.000 sec)
</pre>