[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
Wed Feb 17 20:27:26 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:  Unassigned     
Component:  General       |     Version:  2.9.2          
 Severity:  normal        |    Keywords:  links, wp_links
--------------------------+-------------------------------------------------
 Here is my original post about the issue:
 [http://wordpress.org/support/topic/365540?replies=3]

 In short, the link_url column in the wp_links table has a datatype of
 VARCHAR(255).  As far as I know, there is no pre-defined limit to the
 length of a URL.  However, browsers typically enforce their own practical
 limits, the shortest of which is much larger than the 255 character limit
 that WP is enforcing.  Entering urls longer than 255 characters causes
 them to be truncated.

 I tried altering the table so that link_url has a datatype of
 VARCHAR(1024).  This allowed me to use much larger links without them
 being cut off.  Therefore, I believe that the limiting factor is the DB
 and not some other code within WP.

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


More information about the wp-trac mailing list