Last modified: 2013-02-06 01:31:59 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T37995, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 35995 - No collation support for non-category based lists
No collation support for non-category based lists
Status: NEW
Product: MediaWiki
Classification: Unclassified
General/Unknown (Other open bugs)
1.21.x
All All
: Low normal with 1 vote (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2012-04-15 19:29 UTC by Subfader
Modified: 2013-02-06 01:31 UTC (History)
3 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Subfader 2012-04-15 19:29:26 UTC
In MW 1.17 case insensitive sorting was fixed on category pages so "bar" sorts before "Foo" and not after A-Z.

Lists like [[Special:EditWatchlist]] still sort case sensitive: http://i.imgur.com/O81U6.png

Tested with MySQL, MW 1.16a and trunk on mediawoiki.org
Comment 1 Subfader 2012-04-15 19:38:27 UTC
solution: change watchlist.wl_title collation to something proper like latin1_german... (not latin1_swedish tho)
Comment 2 Subfader 2012-04-15 19:43:56 UTC
edit: maybe not...
Comment 3 Subfader 2012-04-15 19:53:10 UTC
wl_title: varchar(255) / latin1_swedish_ci

This works for me in an extension that uses a similar table like watchlist. Someone please post if this is not correct.
Comment 4 Bawolff (Brian Wolff) 2013-02-06 00:48:19 UTC
(In reply to comment #0)
> In MW 1.17 case insensitive sorting was fixed on category pages so "bar"
> sorts
> before "Foo" and not after A-Z.
> 
> Lists like [[Special:EditWatchlist]] still sort case sensitive:
> http://i.imgur.com/O81U6.png
> 
> Tested with MySQL, MW 1.16a and trunk on mediawoiki.org

The feature was meant only for categories. I don't think we plan on using database collation support. your fix probably wouldn't work if you had non latin1 characters

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links