UTF-8: General? Bin? Unicode?

by

In general, utf8_general_ci is faster than utf8_unicode_ci, but less correct.

Here is the difference:

For any Unicode character set, operations performed using the _general_ci collation are faster than those for the _unicode_ci collation. For example, comparisons for the utf8_general_ci collation are faster, but slightly less correct, than comparisons for utf8_unicode_ci. The reason for this is that utf8_unicode_ci supports mappings such as expansions; that is, when one character compares as equal to combinations of other characters. For example, in German and some other languages “ß” is equal to “ss”. utf8_unicode_ci also supports contractions and ignorable characters. utf8_general_ci is a legacy collation that does not support expansions, contractions, or ignorable characters. It can make only one-to-one comparisons between characters.

Quoted from:
http://dev.mysql.com/doc/refman/5.0/en/charset-unicode-sets.html

For more detailed explanation, please read the following post from MySQL forums:
http://forums.mysql.com/read.php?103,187048,188748

As for utf8_bin:
Both utf8_general_ci and utf8_unicode_ci perform case-insensitive comparison. In constrast, utf8_bin is case-sensitive (among other differences), because it compares the binary values of the characters.

More Related Contents:

  1. What’s the difference between utf8_general_ci and utf8_unicode_ci?
  2. How to make MySQL handle UTF-8 properly
  3. “Incorrect string value” when trying to insert UTF-8 into MySQL via JDBC?
  4. What is the difference between utf8mb4 and utf8 charsets in MySQL?
  5. How to conduct an Accent Sensitive search in MySql
  6. Troubleshooting “Illegal mix of collations” error in mysql
  7. How to change the CHARACTER SET (and COLLATION) throughout a database?
  8. How to remove accents in MySQL?
  9. How to change collation of database, table, column?
  10. Differences between utf8 and latin1
  11. What effects does using a binary collation have?
  12. Incorrect string value: ‘\xF0\x9F\x8E\xB6\xF0\x9F…’ MySQL
  13. MySQL VARCHAR Lengths and UTF-8
  14. Are column and table name case sensitive in MySQL?
  15. How to detect UTF-8 characters in a Latin1 encoded column – MySQL
  16. Fetching UTF-8 text from MySQL in R returns “????”
  17. How to fix double-encoded UTF8 characters (in an utf-8 table)
  18. Illegal mix of collations error in MySql
  19. What is the best MySQL collation for German language
  20. Loading utf-8 encoded text into MySQL table
  21. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  22. MySQL command line formatting with UTF8
  23. MySQL treats ÅÄÖ as AAO?
  24. How to change the default charset of a MySQL table?
  25. SQL doesnt differentiate u and ü although collation is utf8mb4_unicode_ci
  26. Detecting utf8 broken characters in MySQL
  27. MySQL throws Incorrect string value error
  28. MySQL Illegal mix of collations
  29. Mysql server does not support 4-byte encoded utf8 characters
  30. UTF8 problem with MySQL 5

Leave a Comment