Page MenuHomePhabricator

No collation support for non-category based lists
Open, LowPublic

Description

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


Version: 1.21.x
Severity: normal

Details

Reference
bz35995

Event Timeline

bzimport raised the priority of this task from to Low.Nov 22 2014, 12:20 AM
bzimport set Reference to bz35995.
bzimport added a subscriber: Unknown Object (MLST).

solution: change watchlist.wl_title collation to something proper like latin1_german... (not latin1_swedish tho)

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.

(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