What's the difference between the two types of column/table collations? Which is preferred and why? Any thoughts?
+5
A:
This post describes it very nicely.
In short: utf8_unicode_ci uses the Unicode Collation Algorithm as defined in the Unicode standards, whereas utf8_general_ci is a more simple sort order which results in "less accurate" sorting results.
Michael Madsen
2010-01-01 00:31:31
thanks. that was my impression. i'll take the performance hit :)
onassar
2010-01-01 01:51:25