Which Collation in Database structure

[donald.dickson338135]

A quick (basic) question.
I have imported the wa_ecommerce_db database via phpMyAdmin and when I look at structure, column Collation, the preselected type is latin1_swedish_ci
I tried to make some sense of this using the embedded help files, but they assume a greater depth of basic knowledge than I have - i.e. I did not understand the help file!

So, as my default language for the database is English, I am deducing that I need to change for each record in each table the Collation type - but what to? utf8_bin?
Thanks!

[Jason Byrnes]

the default collation for the English language is latin1_swedish_ci.

for most people the latin1_swedish_ci collation is the one to use, dont change it unless you understand what the collation is meant to do.

Database collation is not a beginner topic