how can I get mysql comparisons to be case sensitive?

[unregistered]

Using the C API,
I have a VARCHAR column as my primary key in 2 of my tables and when I try to insert "TEST" and subsequently "Test", the second insertion fails. How can I programmatically make it such that same text with differing cases are treated uniquely?

I'm using prepared statements for the insertion, deletion and update if that means anything...

[NickPaul]

Check this:

http://sql-info.de/mysql/gotchas.html#1_4