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