title: MySQL - Proper "Collation" for case-sensitive text? UTF8-bin?
body: <p>In using MySQL (v5.0.77) there are a lot of choices for Collation. I was originally thinking of <strong>UTF8-general_ci</strong> however MySQL shows it as being case-insensitive which I think would cause problems for objects such as passwords. If I want to use UTF8 but want case-sensitive data should I use <strong>UTF8-bin</strong>? Thanks!</p>