I never knew exactly what it means. I know it has to do with the encoding of the data that will be inserted into the table, but besides, is there any more specific reason to select a collation ?
I have some doubts:
In the case of a database, what would a Collation specifically be?
Depending on the Colattion chosen, can I increase the speed of queries?
Is there any specific advice when using it? Example: Saved data type, region, or character set?
What problems can I have if I do not know which Collation to use when creating a table or database?