Hi, Thanks for the reply Claudia. I looked for more people having the same problem with Postgres and it turns out that it is a problem with most of the UNIX OS's out there. I'm pretty sure we're not the only one with the problems, so I'll just summarize the problem and indicate the solutions.
Apparently the issue is with the locales that inherit LC_COLLATE from iso14651_t1, which sort spaces with lower priority. The workaround in Ubuntu is to edit /usr/share/i18n/locales/en_US (or whatever locale the postgres user is running) and change: 'LC_COLLATE % Copy the template from ISO/IEC 14651 copy "iso14651_t1" END LC_COLLATE' To 'LC_COLLATE % Copy the template from ISO/IEC 14651 copy "iso14651_t1" reorder-after <U00A0> <U0020><CAP>;<CAP>;<CAP>;<U0020> reorder-end END LC_COLLATE' And then reloading the locale (with localedef). I can't give a more detailed explanation because I copied it from somewhere else, but after this is done and postgres is restarted, you just need to reindex the browse lists. Thanks, Rafael Henkin -----Mensagem original----- De: Claudia Juergen [mailto:claudia.juer...@ub.tu-dortmund.de] Enviada em: quinta-feira, 7 de janeiro de 2010 18:02 Para: Rafael Henkin Cc: dspace-tech@lists.sourceforge.net Assunto: Re: [Dspace-tech] Browse authors sorting problem Hello Rafael, this is not a DSpace issue but depends on your database and collation settings, i.e. how the db cluster was initialized (locale used for LC_COLLATE and LC_CTYPE). Hope that helps Claudia Jürgen > Hi, > > > > We're currently testing a Dspace 1.5 instance and noticed a weird issue > regarding the sorting in the browsing lists. Although we have done a few > modifications to DSpace, none of them was related to the configurable > browse. > > > > While looking for authors starting with "lamb", we get the following > results: > > > > "Lamb, Caren Regina Cavichioli > > Lambert, Jose > > Lambert, José > > Lambert, José Humberto Franco > > Lambert, Roger > > Lamberts, Andrea von der Heyde > > Lambiase, Clodoaldo de Borba > > Lamb, Lúcia da Cunha > > Lamb, Luis da Cunha > > Lamb, Roberto" > > > > I expected all the Lamb's to show up before any Lambert or Lambiase, but > that ain't happening. I'm not sure if there's some sort of stemming or > whatever manipulation going on. > > > > Any suggestions? > > > > Thanks, > > > Rafael Henkin > > ------------------------------------------------------------------------------ > This SF.Net email is sponsored by the Verizon Developer Community > Take advantage of Verizon's best-in-class app development support > A streamlined, 14 day to market process makes app distribution fast and > easy > Join now and get one step closer to millions of Verizon customers > http://p.sf.net/sfu/verizon-dev2dev > _______________________________________________ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech > -- Claudia Jürgen Eldorado - Repositorium der TU Dortmund Universitätsbibliothek Dortmund Vogeplothsweg 76 D-44227 Dortmund Tel.: 0049-231-755-4043 ------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
