Ghazanfar Mir Ghazanfar Mir - 14 days ago 5
MySQL Question

Difference between Encoding and collation?

I have seen certain questions and bugs related to

encoding
and
collation
. Could anyone of the visitors explain the difference in
MySQL
domain?

Answer

Encoding refers to that character set used.
Collation determines the sort order.

See: http://dev.mysql.com/doc/refman/5.5/en/charset-general.html