Wednesday 12 June 2019

mysql - 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


-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

php - file_get_contents shows unexpected output while reading a file

I want to output an inline jpg image as a base64 encoded string, however when I do this : $contents = file_get_contents($filename); print &q...