[Using Sakai] [Building Sakai] Weird issue ordering by Lastname

[Feliz Gouveia]

Daniel, I'm not sure if this could be the case but check
https://jira.sakaiproject.org/browse/KNL-696.

For languages with special characters, the collation should be
specified for the locale being used. Otherwise you'll have also
problems ordering with accents and other non-ascii characters. I
remember this was not in the code and we had to do it to sort names.

regards, Feliz


On 26 January 2012 09:44, Daniel Merino <daniel.merino at unavarra.es> wrote:
> Hi everybody.
>
> One of our teachers has reported us a weird issue we hadn't noticed before.
>
> Given two students, whose lastnames are "Martinez Torcal" and "Martin
> Troncoso", these lastnames are written in the LASTNAME field of the
> SAKAI_USER table.
>
> Ordering in the database client, in excel or any other application, the
> logical alphabetical order is first "Martin Troncoso" and after
> "Martinez Torcal", just because the blank space is counted as a character.
>
> However, in our Sakai 2.7.1 with kernel 1.1.13 they are ordered at Site
> Info, Assignments, etc. just the opposite: first "Martinez Torcal" and
> after "Martin Troncoso". The same issue happens with LDAP users.
>
> I have searched at JIRA, but I haven't found any clue about this. Also,
> I have looked at BaseUserDirectoryService in the Kernel code:
>
> http://source.sakaiproject.org/viewsvn/kernel/trunk/kernel-impl/src/main/java/org/sakaiproject/user/impl/BaseUserDirectoryService.java?view=markup
>
> but the getSortName() method doesn't seem to do nothing wrong.
>
> Please, could you tell me if this problem has been reported and solved
> in the past?
>
> Thanks in advance.
> Best regards.
> --
> Daniel Merino Echeverría
> daniel.merino at unavarra.es
> Gestor de teleformación - Centro Superior de Innovación Educativa.
> Tfno: 948-168489 - Universidad Pública de Navarra.
> --
> Donde todos piensan igual nadie piensa mucho. (Walter Lippmann)
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"



-- 
Feliz Ribeiro Gouveia

Universidade Fernando Pessoa            http://www.ufp.pt
Centro de Recursos Multimediaticos      Tel 351-22.507.13.06
M.I.N.D. Lab                            Fax 351-22.550.82.69
Pr 9 de Abril 349                       fribeiro at ufp.edu.pt
P-4249-004 Porto