MySQL case sensitivity for primary key

Question

Are MySQL primary key values case sensitive? If it's an option how do I set it? I want the table to be able to store "www.Example.com" and "www.example.com" as different values.

Accepted Answer

You can set per-column collations in MySQL: https://dev.mysql.com/doc/refman/5.5/en/charset-column.html

e.g. if your table is generally (say) case insensitive, you can override it per-field to be case-sensitive.

MySQL case sensitivity for primary key

Solution

Problem