Menu
I have seen certain questions and bugs related to encoding and collation. Could anyone of the visitors explain the difference in MySQL domain?
747
A character set is a set of symbols and encodings. A collation is a set of rules for comparing characters in a character set.
A collation is a set of rules that defines how to compare and sort character strings. Each collation in MySQL belongs to a single character set. Every character set has at least one collation, and most have two or more collations. A collation orders characters based on weights.
Character Sets and Encoding Schemes The distinction between the two isn't always clear and the terms tend to be used interchangeable. A character set is a list of characters whereas an encoding scheme is how they are represented in binary. This is best seen with Unicode.
A character set is a set of characters while a collation is the rules for comparing and sorting a particular character set. For example, a subset of a character set could consist of the letters A , B and C . A default collation could define these as appearing in an ascending order of A, B, C .
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
190
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
