Difference between Encoding and collation?

Question

I have seen certain questions and bugs related to encoding and collation. Could anyone of the visitors explain the difference in MySQL domain?

Possible duplicate of [What does character set and collation mean exactly?](http://stackoverflow.com/questions/341273/what-does-character-set-and-collation-mean-exactly) — Pmpr.ir, Jun 08 '16 at 22:05

score 19 · Accepted Answer · answered Oct 11 '11 at 11:03

19

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

answered Oct 11 '11 at 11:03

Johan

73,011
23
185
311

score 4 · Answer 2 · edited Apr 12 '17 at 07:32

4

Excellent answers found here, at programmers.SE:

collation defines the behaviour of comparison operators: =, >, <, <=, >= ...

edited Apr 12 '17 at 07:32

Community

1
1

answered May 10 '15 at 19:06

T.Todua

49,021
18
212
206

score 0 · Answer 3 · edited Feb 14 '15 at 21:48

0

I think following qualifies as a better definition for Encoding

Encoding is an algorithm that translates a list of numbers to binary so it can be stored on disk. For example UTF-8 would translate the number sequence 1, 2, 3, 4 like this: “00000001 00000010 00000011 00000100″.

Source: http://www.calipus.com/blog/what-is-the-difference-between-character-sets-encoding-collations/

edited Feb 14 '15 at 21:48

AbcAeffchen

13,612
15
48
65

answered Feb 14 '15 at 21:22

danieljustin

9
1

You only answered half of the question, where is the collation part? – AguThadeus Oct 07 '21 at 05:50

Difference between Encoding and collation?

3 Answers3

Linked