James: After looking at this problem some more, it seems that this is just the nature of the way postgres does "order by". I looked around for some more examples from other dspace institutions where I thought it worked and can't find it now. Could some one try to insert 3 items with the following authors in a test area and see what happens:
Tan, Bill Tanc, Ann Tan, Ray Sort by Author, should theoretically give you: Tan, Bill Tan, Ray Tanc, Ann But it gives you: Tan, Bill Tanc, Ann Tan, Ray I did it in a test area and I see the same results as we are getting in our production server. Thanks! Jose -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James Rutherford Sent: Tuesday, April 24, 2007 2:33 PM To: Jose Blanco Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] author browse weirdness On Tue, Apr 24, 2007 at 12:40:00PM -0400, Jose Blanco wrote: > So is there some sort of postgress config I need to change, is this because > I don't have the latest postgress, or am I missing a patch? I suppose one thing to check would be the encoding of your DSpace database. If you connect to the psql prompt and list all your databases (with \l) it should tell you the encoding. If it's not UNICODE, then that might affect the ordering of results. cheers, Jim -- James Rutherford | Hewlett-Packard Limited registered Office: Research Engineer | Cain Road, HP Labs | Bracknell, Bristol, UK | Berks +44 117 312 7066 | RG12 1HN. [EMAIL PROTECTED] | Registered No: 690597 England The contents of this message and any attachments to it are confidential and may be legally privileged. If you have received this message in error, you should delete it from your system immediately and advise the sender. To any recipient of this message within HP, unless otherwise stated you should consider this message and attachments as "HP CONFIDENTIAL". ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
