Entry

Is stored MySQL data Case Sensitive?

Feb 24th, 2000 12:14
Andrew Sheh, Onno Benschop,

By default MySQL data is store CASE INSENSITVE.  
Therefore, if you insert 'ABC' into a column called 'COMPANY'; you can 
query 'where COMPANY = 'abC' and the result is 1 row.
You can make the data BINARY to force it to be case INsensitive.  See 
related question.
How can I make columns in MySQL case sensitive?