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

5 votes162 views1 answer
Get column name sql server
SQL
0 vote186 views1 answer
Postgres list tables and row counts
SQL
0 vote138 views1 answer
Rabbitmq service not starting
SQL
0 vote151 views1 answer
Postgres week number
SQL
5 votes162 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
0 vote139 views1 answer
Print orcale
SQL
3 votes155 views2 answers
Sql not contains
SQL
5 votes172 views6 answers
In operator sql
SQL
25 votes160 views6 answers
Import mysql database command line
SQL
0 vote148 views1 answer
Sqlite version check
SQL