[wp-trac] [WordPress Trac] #10483: Change post_name's length from 200 to 400
WordPress Trac
wp-trac at lists.automattic.com
Sat Mar 19 10:47:22 UTC 2011
#10483: Change post_name's length from 200 to 400
--------------------------+-----------------------------
Reporter: elnur | Owner: ryan
Type: enhancement | Status: reopened
Priority: low | Milestone: Future Release
Component: Permalinks | Version:
Severity: minor | Resolution:
Keywords: dev-feedback |
--------------------------+-----------------------------
Comment (by linuxologos):
Replying to [comment:13 hakre]:
> Replying to [comment:12 linuxologos]:
> > Thanks for giving the opportunity to discuss this.
> >
> > This is quite a big problem for languages with an alphabet totally
different from English. We can't have a post_name with more than ~38
letters, since '''every''' letter is urlencoded to be stored in the
database, so every letter is converted into many more characters,
dramatically cutting down the maximum possible length of the "real" post-
name.
>
> It's probably worth to drop the urlencoding then inside the storage
layer. AFAIK MySQL should be able to store UTF8 in colums, so to have 200
true UTF8 characters instead of 38 to 200 urlencoded, subset of us-ascii
ones.
>
> The related refactorings could benefit the overall UTF8 support of the
application as a bonus.
MySQL is able to store UTF8 indeed and that is already the fact for
post_content and post_title in (wp_)posts table. They don't get urlencoded
before stored in the db. post_name ''is'' urlencoded though, and I'm not
sure if it's technically safe to alter this.
--
Ticket URL: <http://core.trac.wordpress.org/ticket/10483#comment:14>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software
More information about the wp-trac
mailing list