Member Listing Sort Order - "odd"

[Migrated From Jforum.net]

I found it in an oracle-specific query in oracle.sql.

I changed it to order by user_id descending, so the latest entry would be on top.

I could, alternatively have sorted it by upper(username), or whatever else i WANTED. I tried several variations, and like seeing the latest registered users first, in reverse order of registration.

Thanks,
Jennifer
[originally posted on jforum.net by jenamon]

[Migrated From Jforum.net]

When I look at my member listing, it's oddly sorted. It appears to be sorted generally in order of registration, or user #, but not really. The first 29 users are on page 1, but they are sorted on that page in case-sensitive alpha order by username. Then, the next 30 users (why 29 on page 1) are displayed on page, 2, again sorted in case-sensitive alpha order. That results in an order that looks like this:

Page 1 (users 1-29):
Axxx
Bxxx
Cxxx
...
Zxxx
axxx
bxxx
cxxx
...
zxxx

Page 2 (users 30-59):
Axxx
Bxxx
Cxxx
...
Zxxx
axxx
bxxx
cxxx
...
zxxx

Can someone please point me to the code that might be doing this. I'd prefer either a straight case-INsensitive sort across all pages, or a sort by user number or reverse user number, across all pages. The alpha sub-sort on each page is enough to drive one to drink.

This is v2.1.7, with Oracle and tomcat.

Thanks,
Jennifer
[originally posted on jforum.net by jenamon]

[Migrated From Jforum.net]

The sql statement itself can be found in the engine dependand sql files for selections ...

But: as far as I know it's the collation being used that is responsible for ordering - hence take a look at the collation setting in the conf / db server conf ... and reconfigure your db server possibly... to use the collation that will sort the way you like ... ^^
[originally posted on jforum.net by Sid]