title: MySQL sorting not working as expected
body: <p>I have one table named companies as below.</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `companies` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `name` varchar(40) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
  </code></pre>
  
  <p>and MySQL talbe data for this table is as below.</p>
  
  <pre><code>INSERT INTO `companies` (`id`, `user_id`, `name`) VALUES
  (1, 2, 'Mylan'),
  (2, 1, 'Intas'),
  (3, 48, 'Glenmark'),
  (4, 21, 'Amipharma'),
  (5, 1, 'XEPA SOUL');
  </code></pre>
  
  <p>now when i sort record using below query</p>
  
  <pre><code>SELECT * FROM companies ORDER BY name ASC;
  </code></pre>
  
  <p>this i returnning. </p>
  
  <ul>
  <li>XEPA SOUL</li>
  <li>Amipharma</li>
  <li>Glenmark</li>
  <li>Intas</li>
  <li>Mylan</li>
  </ul>
  
  <p>and this is wrong as <code>X</code> is coming first and its must be shown last.</p>
  
  <p>I do not know why its like this.</p>
  
  <p>Please give some hint or explanation so i could correct this.</p>
  
  <p>Thanks</p>