This article is a couple of years old, but still more or less accurate: http://yob.id.au/2008/05/08/thinking-sphinx-and-unicode.html
A related issue that you may run into is sorting fields with accents. To do that I use a solution similar to the one outlined here: http://stackoverflow.com/questions/1029204/accent-iansensitive-ordering-in-sphinx/1029961 -- James Healy <[email protected]> Thu, 25 Mar 2010 21:17:19 +1100 snusmu 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. > -- 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.
