MySQL treats ÅÄÖ as AAO?

by

Yes, this is standard behaviour in the non-language-specific unicode collations.

9.1.13.1. Unicode Character Sets

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”):

Ä = A
Ö = O
Ü = U

See also Examples of the effect of collation

You need to either

  • use a collation that doesn’t have this “feature” (namely utf8_bin, but that has other consequences)

  • use a different collation for the query only. This should work:

     select * from topics where name="Harligt" COLLATE utf8_bin;

it becomes more difficult if you want to do a case insensitive LIKE but not have the Ä = A 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.

Related:

More Related Contents:

  1. What’s the difference between utf8_general_ci and utf8_unicode_ci?
  2. What is the best MySQL collation for German language
  3. Trouble with UTF-8 characters; what I see is not what I stored
  4. How do I see what character set a MySQL database / table / column is?
  5. What is the difference between utf8mb4 and utf8 charsets in MySQL?
  6. Troubleshooting “Illegal mix of collations” error in mysql
  7. How to display UTF-8 characters in phpMyAdmin?
  8. UTF-8: General? Bin? Unicode?
  9. What is the best collation to use for MySQL with PHP? [closed]
  10. How to change the CHARACTER SET (and COLLATION) throughout a database?
  11. How to change collation of database, table, column?
  12. How to store unicode in MySQL?
  13. What effects does using a binary collation have?
  14. What are the differences between utf8_general_ci and utf8_unicode_ci? [duplicate]
  15. MySQL VARCHAR Lengths and UTF-8
  16. Are column and table name case sensitive in MySQL?
  17. Illegal mix of collations error in MySql
  18. Does MySQL Regexp support Unicode matching
  19. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  20. How to change the default charset of a MySQL table?
  21. MySQL matching unicode characters with ascii version
  22. MySQL Illegal mix of collations
  23. MySQL: Querying for unicode entities
  24. UTF8 problem with MySQL 5
  25. MySQL: Get character-set of database or table or column?
  26. How to do a regular expression replace in MySQL?
  27. Count the number of occurrences of a string in a VARCHAR field?
  28. How to import a CSV file into a MySQL table
  29. How do I select between the 1st day of the current month and current day in MySQL?
  30. MySQL errorno 121

Leave a Comment