title: MySQL Concat Chinese Character Return NULL
body: <p>I want to search with LIKE operator in two column of a table. Column names are : person_first_name, person_last_name . And i found a way for the search two columns like one column. The way is columns must be <strong>CONCAT</strong> and search in the concated string but my values are Chinese language. I want to search in concated Chinese words. In earlier I have searched Chinese language with this way "<em>COLLATE UTF8_GENERAL_CI</em>" but that's not work in concated string. I have tried many method but i didn't get true result.</p>
  
  <p>Example:</p>
  
  <pre><code>SELECT * FROM (`dm_account` a) WHERE CONCAT(a.person_first_name, ' ', a.person_last_name) COLLATE UTF8_GENERAL_CI LIKE '%ANY CHINESE CHARACTER%' ORDER BY `a`.`createdate` asc;
  </code></pre>
  
  <p>But this query does not return to me any record.</p>
  
  <pre><code>SELECT CONCAT(a.person_first_name, ' ', a.person_last_name) FROM dm_account WHERE id=2184;
  </code></pre>
  
  <p>This query does not show me combined words. But this user has got name and last name.</p>
  
  <p>Anybody can help me?
  Thanks.</p>