Ajax autocomplete not case insensitive

[eluser]zulubanslee[/eluser]
That did not work. Here is what I ended up going with.

Code:

$q=$_POST["city_string"];
   $a = '';
   $sql= "SELECT DISTINCT city, state_name
      FROM zip_code
      WHERE city  COLLATE UTF8_GENERAL_CI LIKE ".$this->db->escape($q.'%')."";  
      
  $city_state_result = $this->db->query($sql, array($q));