MYSQL Column Collations: Difference between latin1 and latin2

1.6k views Asked by At

I was currently setting up a database for a webpage when I ran over the Column Collations latin1 and latin2 in PhpMyAdmin. After research on the difference, the only thing I found was that latin1 is for west-europeans and latin2 for central-europeans. What´s the difference in the charset, though?

1

There are 1 answers

1
Rick James On BEST ANSWER

The Charset is what is different. The Collation is the ordering of the characters; since there are different characters in the two charsets, it is not relevant to talk about differences in collation.

First pick latin1 or latin2 based on what characters you need. (Better yet, pick utf8 so you can get both sets of characters.) Second, pick the collation desired. (Often, the default collation is "good enough".)