title: How to convert a column with "character set latin1 collate latin1_bin" into utf8 in Mysql?
body: <p>Ok, in the existing table,</p>
  
  <pre><code>CREATE TABLE tb(id int, `text` varchar(255) character set latin1 collate latin1_bin default NULL)ENGINE=InnoDB DEFAULT CHARSET=latin1
  </code></pre>
  
  <p>I want to make the <code>text</code> column to be <code>utf8</code> and it supports Case Sensitive for <code>select</code> query</p>
  
  <p>Suppose there is "<code>ã</code>" &amp; "<code>Ã</code>" which is <code>utf8</code> in the <code>text</code> column</p>
  
  <pre>
  id - text
  1  - ã
  2  - Ã
  </pre>
  
  <p>, and when user <code>select * from tb where text='Ã'</code>it should show record with id=2 only</p>
  
  <p>Is this query the correct one</p>
  
  <pre><code>alter table tb modify column text varchar(255) character set utf8 collate utf8_general_ci default NULL
  </code></pre>
  
  <p>I have no idea what <code>utf8_general_ci</code> means? am i doing cortrectly?</p>