title: mysql collation type for multilanguage support
body: <p>I'm creating a website that'll store tutorial videos in several different languages. English will be the primary audience, but I expect french accents to be used in usernames/pwds along with swedish/norwegian accents/characters as well.</p>
  
  <p>The languages for the tutorial videos will also be offered in chinese (both cantonese/mandarin), urdu/hindi, farsi/dari, and arabic. While I'm pretty sure the last few use standard qwerty keyboards for the net, especially to register online with - I do know that european keyboards vary and have several accents and ligatures to them.</p>
  
  <p>I was wondering as far as mysql is concerned in terms of storing usernames and email addresses, which collation type would be best suited to support the most probable entries? I know I probably cannot cover them all, but I'd like to do as much as possible.</p>
  
  <p>I've read that uft8_general_ci is better, but how would it vary from latin_1 swedish_ci if I'm looking to support those scandanavian characters?</p>
  
  <p>EDIT:
  the user_id field and email fields will be unique - so fred@home.com would not be the same as fréd@home.com</p>