Which default database collation for an english website?

Question

I am starting up my installation of Magento and just wondered what people recommend is the best collation to use for my database?

It will be an english based website, however it will more than likely include multi-lingual later on however (e.g German, French etc...)

score 3 · Accepted Answer · answered Mar 07 '14 at 10:06

3

I think you can use

utf8_general_ci

answered Mar 07 '14 at 10:06

TechGuy

score 0 · Answer 2 · edited May 23 '17 at 10:24

0

Either utf8_unicode_ci or utf8_general_ci will work.

For explanations as to the differences between the two, consult

to find which will give you better results.

edited May 23 '17 at 10:24

Community

answered Apr 19 '15 at 21:00

Fiasco Labs

2 Answers2