- When I search for an special character that's not in english language I get no results, no matter if the character is in the title of any product.
- When I do the same on the onlune setup it returns all the results that includes special characters and also their simplification, i.e. if I search ofr "ö" I get all the products wiith the "ö" character plus all the ones that includes a regular "o". Same happens with other special characters (ñ returns also n, á returns also a, ç returns also c and so on. So phoenix nicely returns some kind of "sloppy search" so it doesn't matter if you don't type special characters correctly.
For debugging the problem with USU first I have to find out why my local setup is not returning the correct results because it's not practical uploading files by ftp when coding -so if you have some ideas about where to look at please let me know!
Edit: local setup is corrupting characters on search query:
Code: Select all
AND pd.language_id = 1 AND ((pd.products_name LIKE '%�%' OR p.products_model LIKE '%�%' OR m.manufacturers_name LIKE '%�%') )