[wp-trac] [WordPress Trac] #12264: links truncated: link_url column in wp_links table -- datatype too small

WordPress Trac wp-trac at lists.automattic.com
Tue Feb 23 02:47:12 UTC 2010


#12264: links truncated: link_url column in wp_links table -- datatype too small
--------------------------+-------------------------------------------------
 Reporter:  goto10        |       Owner:                          
     Type:  defect (bug)  |      Status:  new                     
 Priority:  normal        |   Milestone:  Future Release          
Component:  General       |     Version:  2.9.2                   
 Severity:  normal        |    Keywords:  2nd-opinion dev-feedback
--------------------------+-------------------------------------------------

Comment(by goto10):

 Thank you for your response dd32.

 Because I keep getting contradictory information on the HTTP URI length
 specification, I have decided to look at the official docs:

 [http://www.w3.org/Protocols/rfc2616/rfc2616-sec3.html]
 3.2.1 General Syntax (paragraph 2 and accompanying note)

 In short, according to rfc2616: "The HTTP protocol does not place any a
 priori limit on the length of a URI."


 For the datatype, I am unsure of which would be more memory efficient,
 even after reading this doc: [http://dev.mysql.com/doc/refman/5.0/en
 /string-type-overview.html]

 The maximum storage size of both VARCHAR and TEXT in versions of mySQL >=
 5.0.3 is 65,535 bytes.  It seems that it would not matter either way, but
 I suspect that one method may be preferred over another as a matter of
 best practice.  I'm quite curious about this.

 I think everyone can agree that URIs over 255 characters are common enough
 that they should be supported.  And if there is a limit, it shouldn't be
 WordPress that is enforcing it.

 I should also note that I am not an expert, and that this is my first bug
 report :)

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


More information about the wp-trac mailing list