What Collation is the best for data type INT in MySQL?

Question

When a filed is INT(data type), what should I choose as collation in MySQL?

Answer 1

Collation affects string sorting. It doesn't have any effect on numeric data types.

It may, howevever, have an effect on how numbers embedded in strings are sorted. But that's still no effect on numeric data types such as INT.

Answer 2

As far as I know, you can specify a collation (or a character set for that matter) only for string types, ie. the types VARCHAR, CHAR, ENUM, SET, and TEXT types (TINYTEXT, TEXT, MEDIUMTEXT, LONGTEXT)

Roland Bouman http://rpbouman.blogspot.com/