title: Issue with uppercase and lowercase using MySql Springdata and Hibernate
body: <p>I have a database which contains an Assignment table. The table looks like this:</p>
  
  <pre><code>ID | CHARACTER_ASS | TYPE_ASS
  </code></pre>
  
  <p>Inside the character column letters and numbers are stored. Ie. 'A', 'a', "Aa". "AA", 1 etc...
  Now when i execute the following query in my query console:</p>
  
  <pre><code>select * from assignment a where a.CHARACTER_ASS = 'A'
  </code></pre>
  
  <p>It will return the lowercase entry in my database and the uppercase entry as well. Now I've been looking for an answer to this question and someone told me that this might because I'm running on a Windows OS. I've looked this up and could only find that there could be a problem with naming table names with/without lowercase (?).</p>
  
  <p>One of the other problems is that I'm using spring data. In spring data I don't have direct control of the query so I'm wondering if there is a specific fix for spring data.</p>
  
  <p>I'd like to hear your answers regarding this issue :)</p>
  
  <p>Thanks in advance</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>My SHOW CREATE TABLE assignment:</p>
  
  <pre><code>CREATE TABLE `assignment` (
    `ID` int(11) NOT NULL AUTO_INCREMENT,
    `CHARACTER_ASS` varchar(45) NOT NULL,
    `TYPE_ASS` int(11) NOT NULL,
    PRIMARY KEY (`ID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8
  </code></pre>
  
  <p><strong>EDIT2</strong></p>
  
  <p>I changed my Assignment table Collation to: latin1_general_cs and I tried querying manually in the MySql query editor, but I still get A and a back as result.
  Then i tried to adjust the collation of the table to the same value as I did with the table. 
  Am i doing something wrong or should the adjustment work?</p>
  
  <p><strong>EDIT3</strong></p>
  
  <p>Ok I just fixxed it. Instead of using the latin1_general_cs I used utf8_bin. Seems that utf8 doesn't have a Case Sensitive Collation :) Thank you JB Nizet for pointing me in the right direction! </p>