hi all, i need sphinx to ignore accents while searching, so that if i search for example for "Débats" it would find "Debats"
is there any option which allows that in the engine or plugin? if not, then i think i will use the solution to replace accents in indexable values. so that define_index do indexes name end will become something like (not tested) define_index do indexes "REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( REPLACE(REPLACE(name,'À','a'),'Á','a'),'Â','a'),'Ã','a')','a'),'Ä','a'),'Å','a'),'à','a'),'á','a'),'â','a'),'ã','a'),'ä','a'),'å','a'),'Ò','o'),'Ó','o'),'Ô','o'),'Õ','o'),'Ö','o'),'Ø','o'),'ò','o'),'ó','o'),'ô','o'),'õ','o'),'ö','o'),'ø','o'),'È','e'),'É','e'),'Ê','e'),'Ë','e'),'è','e'),'é','e'),'ê','e'),'ë','e'),'Ç','c'),'ç','c'),'Ì','i'),'Í','i'),'Î','i'),'Ï','i'),'ì','i'),'í','i'),'î','i'),'ï','i'),'Ù','u'),'Ú','u'),'Û','u'),'Ü','u'),'ù','u'),'ú','u'),'û','u'),'ü','u'),'ÿ','y'),'Ñ','n'),'ñ','n')", :as => :name end since i have much more models and attributes to index, i will probably put that into mysql stored function; i'd be thankful if anyone which encountered the problem and knows how to improve the solution would share the knowledge thanks in advance -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
