[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:37:00 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 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.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/10483#comment:13>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software


More information about the wp-trac mailing list