* (bug 13768) pt_title field encoding fixed
authorBrion Vibber <brion@users.mediawiki.org>
Thu, 17 Apr 2008 19:11:36 +0000 (19:11 +0000)
committerBrion Vibber <brion@users.mediawiki.org>
Thu, 17 Apr 2008 19:11:36 +0000 (19:11 +0000)
commit2368dd5bf11c34b819fbd74fd46ca2fa04671dd5
tree81e287abb00d12661df72dfa092e53abda2a6cc1
parent32dbdb6e00ab735102bd32b868e5fd7963017e98
* (bug 13768) pt_title field encoding fixed
pt_title field in page_protections was added without a binary marker when used on non-binary schema.
This means you get false matches for ASCII case-insensitive bits, and probably for horribly wrong UTF-8 mish-mashes as well.

Adds an updated to fix the field's encoding to binary, matching all our other title keys,
so you can join and get correct matches.

Revert r33473, which seems to assume that pt_title is supposed to be case-insensitive.
(Even if it was, it woudln't work correctly as written.)
RELEASE-NOTES
includes/api/ApiQueryInfo.php
maintenance/archives/patch-protected_titles.sql
maintenance/archives/patch-pt_title-encoding.sql [new file with mode: 0644]
maintenance/tables.sql
maintenance/updaters.inc