Mysql collation

Database collation mysql

The main difference is sorting accuracy (when comparing characters in the 
language) and performance. The only special one is utf8_bin which is for 
comparing characters in binary format.

utf8_general_ci is somewhat faster than utf8_unicode_ci, but less accurate 
(for sorting). The specific language utf8 encoding (such as utf8_swedish_ci) 
contain additional language rules that make them the most accurate to sort for 
those languages. Most of the time I use utf8_unicode_ci (I prefer accuracy to 
small performance improvements), unless I have a good reason to prefer a 
specific language.

You can read more on specific unicode character sets on the MySQL manual - 
http://dev.mysql.com/doc/refman/5.0/en/charset-unicode-sets.html

Source: grepper.com

Similar codes

0 vote166 views1 answer
How to fetch highest score in minimum time using mysql
SQL
10 votes198 views5 answers
Mysql create user
SQL
17 votes212 views4 answers
Show tables sql server
SQL
5 votes194 views1 answer
Oracle list functions
SQL
1 vote180 views1 answer
Mysql order by desc null last
SQL
0 vote204 views1 answer
Mysql update set sum
SQL
0 vote198 views1 answer
Sql count matching group by
SQL
11 votes188 views2 answers
MySQL DISTINCT
SQL
14 votes204 views4 answers
Import database through command line
SQL
0 vote186 views1 answer
Select only one row sql
SQL