title: How can I find non-ASCII characters in Codeigniter query?
body: <p>The below query I have tried for mysql and it works fine but I need this in the form of codeigniter active record class.   </p>
  
  <pre><code>SELECT name FROM tblmarkets_football WHERE name &lt;&gt; CONVERT(name USING ASCII);
  </code></pre>
  
  <p>I tried something like this but it's not working I'm getting 500 error.....</p>
  
  <pre><code>$wherestr = 'tblmarkets_football.name &lt;&gt;'. CONVERT(tblmarkets_football.name. ' USING ASCII');
  $this-&gt;db-&gt;select('*');
  $this-&gt;db-&gt;from('tblmarkets_football');
  $this-&gt;db-&gt;join('tblmarkets','tblmarkets.id = tblmarkets_football.market_id','left');
  $this-&gt;db-&gt;where($wherestr);
  </code></pre>