0

Is possible to "learn" codeigniget to recognize chars like ľščťžýáíé or ĽŠČŤŽÝÁÍÉ ? Cause I want not to have search sensitive to those chars. For example if I have in my table row "Šilíoá" and I search for silioa nothing will be foung. But if I am searching for silioa it will be found. So I think that problem is in Š is it possible for example to learn codeigniter to recognize Š? Or Ž etc.? Here is my query:

$q = $this->db->query("SELECT * FROM (`knihy`) 
                  WHERE `stav` = 1 
                  AND (Autor1 LIKE '$vyraz' 
                  OR Autor2 LIKE '$vyraz' 
                  OR Autor3 LIKE '$vyraz' 
                  OR Autor4 LIKE '$vyraz') 
                  ORDER BY `id` desc LIMIT $limit OFFSET $offset ");
Geril
  • 159
  • 1
  • 15

1 Answers1

0

I think this is more related to MySQL then CI. Maybe this will help you:

  1. Php/MySql array search with ã, š, é, ë, ú, ü, í, ž
  2. Reading signs like č ć đ š ž from MySql database
Community
  • 1
  • 1
Alexandru Guzinschi
  • 5,675
  • 1
  • 29
  • 40