What Collation Should I Make My MySQL Database In?

Default is latin1_swedish_ci

should I change this

I am from the united states building a db for a shopping cart 80% of customers are from the US; the rest are international.

1 Answer

  • 1 decade ago
    Favorite Answer

    Use the utf8 character set with a utf8_swedish_ci collation. This will allow international characters but sort them Latin-wise (Latin characters before non-latin ones).

Still have questions? Get your answers by asking now.