MySQL answer: utf8_unicode_ci vs. utf8_general_ci.
Collation controls sorting behavior. Unicode rationalizes the character set, but doesn’t, on it’s own, rationalize sorting behavior for all the various languages it supports. utf8_general_ci (ci = case insensitive) is apparently a bit faster, but sloppier, and only appropriate for English language data sets.
Posted May 11, 2009 by Casey
Categories: Dispatches. Tags: collation, mysql, utf8, utf8_general_ci, utf8_unicode_ci.
No Comments Yet
No comments yet.
Comments RSS
TrackBack Identifier URI
User contributed tags for this post:
utf8_unicode_ci vs utf8_general_ci (13) - utf8_unicode_ci (13) - utf8_general_ci (12) - utf8_general_ci utf8_unicode_ci (9) - mysql utf8_general_ci (6) - mysql utf8_unicode_ci (6) - difference between utf8_general_ci and utf8_unicode_ci (6) - utf8_unicode_ci utf8_general_ci (5) - utf8_unicode_ci or utf8_general_ci (5) - utf8_general_ci vs utf8_unicode_ci (4) - mysql collations (3) - BETWEEN mysql (2) - utf8_general mysql (2) - utf8_general_ci utf8_unicode_ci difference (2) - utf8_general_ci difference mysql (2) - utf-8_general_ci mysql 5 (2) - mysql utf8_general_ci case sensitive (2) - mysql utf8_unicode_ci vs utf8_general_ci (2) - utf8_unicode_ci and utf8_general_ci (2) - CAST utf8_general_ci utf8_unicode_ci (2) - mysql utf8_general_ci utf8_unicode_ci (2) - mysql difference utf8_general_ci utf8_unicode_ci (2) - mysql utf8_general_ci collation (2) - wordpress utf8_general_ci (2) - utf8_general_ci in mysql (1) - wordpresss utf8_unicode_ci vs utf8_general_ci (1) - utf8_general_ci mysql change Collation (1) - mysql utf8_unicode_ci to utf8_general_ci (1) - utf8_unicode_ci vs utf8_general (1) - utf8_unicode vs utf8_general (1) - difference in mysql (1) - mysql utf8_general case sensitive (1) - mysql collation utf8_general_ci utf8_unicode_ci (1) - utf8_unicode_ci difference (1) - collation utf8_general_ci utf8_unicode_ci (1) - utf8_general_ci vs utf8_unicode (1) - utf8_general utf8_unicode (1) - mysql what is utf8_general_ci (1) - utf8_general_ci utf8_unicode (1) - xml utf8_general_ci (1) - mysql utf8_unicode_ci case sensitiv (1) - utf8_unicode_ci vs utf8_general_ci performance (1) - Mysql utf8_general_ci case sensitivity (1) - utf8_unicode utf8_general (1) - mysql differences between utf8_unicode and utf8_general (1) - utf8_unicode_ci cast to utf8_general_ci (1) - defrent between utf8_unicode_ci and utf8_general_ci (1) - set collation utf8_general_ci (1) - utilizar DIFF en mysql (1) - diff b/w utf8_unicode_ci utf8_general_ci (1) - utf8_unicode_ci czy utf8_general_ci (1) - difference between utf8_unicode_ci and utf8_general_ci (1) - mysql (1) - mysql utf8_general_ci utf8_unicode_ci difference (1) - how much faster is utf8_general_ci utf8_unicode_ci (1) - utf8_general_ci for english (1) - collation utf8_general_ci case insensitive (1) - utf8_general_ci vs. utf8_unicode_ci (1) - collation utf8_general vs utf8_unicode (1) - sorting utf8_unicode_ci (1) - mysql utf8_unicode_ci utf8_general_ci (1) - mysql utf8_general utf8_unicode (1) - utf8_general_ci mac (1) - mysql sort collation (1) - utf8_general_ci collation (1) - utf8_general_ci āļāļąāļ utf8_unicode_ci (1) - mysql utf8_general (1) - diff between utf8_unicode_ci and utf8_general_ci (1) - utf8_unicode_ci collation (1) - difference utf8_unicode_ci (1) -
