title: is it possible to make MySQL Db to store data in Uppercase without UPPER() function
body: <p>I was looking to make the data in my MySQL table to be UPPERCASE no matter what case was used as input. Going through some docs and online contents I found the <code>UPPER()</code> function which will convert the data to UPPERCASE. But I want to know if there is any default option in MySQL which can convert the data to UPPERCASE without using <code>UPPER()</code> function.</p>
  
  <p><strong>Example:</strong></p>
  
  <pre><code>INSERT INTO table(name) VALUES('ironman') WHERE id=1;
  </code></pre>
  
  <p><strong>The MySQL DB should look like this:</strong></p>
  
  <pre><code>id name 
  1  IRONMAN
  </code></pre>