ehm, just found previous message on the subject, so i think i'll manage that
http://groups.google.com/group/thinking-sphinx/browse_thread/thread/ffd985f0aa28dd9d/b162efaff26abd49?lnk=gst&q=accents#b162efaff26abd49 regards, Pavel K. On Mar 25, 11:11 am, snusmu <[email protected]> wrote: > 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.
