Page MenuHomePhabricator

Length of title can only be 255 chars
Closed, DeclinedPublic

Description

The length of a title is stored as a varchar(255), so only titles with <=255 chars are allowed. On de.wikipedia we had the problem that someone wanted to create a page with a longer title[1] (FYI: It was the title of a German law. Those are always very long).

I don't think this is really important bug (because you nearly always find a shorter and more practical title), but it should be noted somewhere.

[1] Permalink: http://de.wikipedia.org/w/index.php?title=Wikipedia:Fragen_zur_Wikipedia&oldid=42682354#Hyperlink_geht_nicht


Version: unspecified
Severity: minor

Details

Reference
bz13057

Event Timeline

bzimport raised the priority of this task from to Lowest.Nov 21 2014, 10:02 PM
bzimport set Reference to bz13057.
bzimport added a subscriber: Unknown Object (MLST).

Fixing this wil need an schema change.

Bryan.TongMinh wrote:

Note that the limit is 255 bytes, so two byte scripts like Arab get only 128 characters and three byte scripts even less.

However the MySQL in use by Wikimedia has problems/does not support varchars larger than 255. Domas talked about this some time ago on #wikimedia-tech and should have some data around about large titles.

Presently we have no intention of increasing this limit.