StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Yes, this is standard behaviour in the non-language-specific unicode collations. </p> <p><a href="http://dev.mysql.com/doc/refman/5.1/en/charset-unicode-sets.html" rel="nofollow noreferrer">9.1.13.1. Unicode Character Sets</a></p> <blockquote> <p>To further illustrate, the following equalities hold in both utf8_general_ci and utf8_unicode_ci (for the effect this has in comparisons or when doing searches, see Section 9.1.7.7, “Examples of the Effect of Collation”):</p> <p>Ä = A Ö = O Ü = U</p> </blockquote> <p>See also <a href="http://dev.mysql.com/doc/refman/5.1/en/charset-collation-effect.html" rel="nofollow noreferrer">Examples of the effect of collation</a></p> <p>You need to either</p> <ul> <li><p>use a collation that doesn't have this "feature" (namely <a href="https://stackoverflow.com/questions/5526334/what-effects-does-using-a-binary-collation-have"><code>utf8_bin</code></a>, but that has other consequences)</p></li> <li><p>use a different collation <em>for the query only</em>. This should work:</p> <pre><code>select * from topics where name='Harligt' COLLATE utf8_bin; </code></pre></li> </ul> <p>it becomes more difficult if you want to do a case insensitive <code>LIKE</code> but <strong>not</strong> have the <code>Ä = A</code> umlaut conversion. I know no mySQL collation that is case insensitive and does not do this kind of implicit umlaut conversion. If anybody knows one, I'd be interested to hear about it.</p> <p>Related:</p> <ul> <li><a href="https://stackoverflow.com/questions/2044268/looking-for-case-insensitive-mysql-collation-where-a-a">Looking for case insensitive MySQL collation where “a” != “ä”</a></li> <li><a href="https://stackoverflow.com/questions/901066/mysql-case-sensitive-search-for-utf8-bin-field">MYSQL case sensitive search for utf8_bin field</a></li> </ul>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload