Hi Pedro Unfortunately, Sphinx only supports sorting on attributes - and so, the charset table settings don't get applied (they're only for fields). You're going to need a denormalised column (or a function that ends up with the same value) to make this reliable.
Sorry - perhaps Sphinx will be a bit more flexible with this in the future. -- Pat On 21/03/2011, at 9:26 AM, Pedro Cunha wrote: > Hello, > > I browsed over web to accomplish sorting accented attributes and > solution is pointing to: > > => has "LOWER(field_name)", :as => :field_name, :type => :string > > This don't seem to be working. > > > Seems like having a particular charset table only works for index > fields, meaning, I can search over words with accented chars like they > are just normal, but same doesn't happen on attributes. > > Is there something wrong on configuration or do I really need to have > a normalized column for sorting? > > > Best regards, > Pedro > > -- > 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.
