CHAR fields with a table default charset of "binary" are silently converted to the BINARY field type, which automatically pads data with null characters on the right. This occurs in a number of places in the MW 1.10 binary schema. These null characters are exposed to MediaWiki causing various bugs. The solution (discussed with Domas on MediaWiki-General) is to use VARCHAR instead of CHAR in all the relevant places, which will be silently converted to VARBINARY. VARBINARY has a length byte and is thus capable of binary-safe storage of variable-length fields.
Version: 1.10.x
Severity: major