Just to clarify my typo and this seems to be working Model.search "", :order => fieldname_sort ASC
On Mar 24, 12:23 pm, Pedro Cunha <[email protected]> wrote: > Back to the topic. > > Using: > > => indexes column_which_has_content_with_accents, :as > => :fieldname, :sorting => true > > + > > => charset_table > > Model.search "", :sort => fieldname_sort ASC > > Properly sorts accented words! > > Best regards :) > > On Mar 23, 3:56 pm, Pedro Cunha <[email protected]> wrote: > > > > > > > > > Thanks for this information. > > > Best regards, > > Pedro > > > On Mar 22, 1:32 pm, Pat Allan <[email protected]> wrote: > > > > 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 > > > > athttp://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.
