Re: Case sensitive in MySQL

This isn't really a Perl question, but I've encountered this class of problem before. To make MySQL columns case-sensitive, use the BINARY keyword, eg.:

CREATE TABLE foo (
   mystring CHAR(10) BINARY
);
[download]

Comment on Re: Case sensitive in MySQL Download Code

Replies are listed 'Best First'.
Re^2: Case sensitive in MySQL by ghettofinger (Monk) on Jan 29, 2005 at 21:45 UTC
I am amazed that you decyphered this. Hats off to you.	[reply]
Re^2: Case sensitive in MySQL by superfrink (Curate) on Jan 30, 2005 at 06:36 UTC
Also of note is that you can use the BINARY keyword in your query without using a BINARY colunn. For example: `SELECT 'abc' LIKE BINARY 'ABC';` [download]	[reply] [d/l]