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 decade agoFavorite 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).