ycTIN

The utf8_general_ci and utf8_unicode_ci are most popular collations for utf8 charset in MySQL database. But a lot of peoples do not know the different between utf8_general_ci and utf8_unicode_ci.

The major different is utf8_general_ci is faster than utf8_unicode_ci but utf8_unicode_ci is more accurate when searching German and French contents.

utf8_unicode_ci
ß equal ss

utf8_general_ci
ß not equal ss

The utf8_general_ci is better if you do not need to search in German or French,  otherwise utf8_unicode_ci is fine.

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

Related posts:

1. [PHP] Dreamweaver too many connections error I am not using dreamweaver to develop my php code,...