Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Archive › eCommerce mySQL Database › Which Collation in Database structure

Which Collation in Database structure

Thread began 11/21/2010 9:35 am by donald.dickson338135 | Last modified 11/22/2010 8:19 am by Jason Byrnes | 2384 views | 1 replies |

11/21/2010 9:35 am | #1 donald.dickson338135

Which Collation in Database structure

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!

11/22/2010 8:19 am | #2 Jason ByrnesWebAssist

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

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.