[wp-hackers] Link Table Description Length

Jason Webster jason at intraffic.net
Tue Dec 9 01:03:03 GMT 2008

mySQL < 5.0.3 does not support varchar's longer than 255.
You'd have to change datatypes for what you're proposing.

Jared Havican wrote:
> The current table design wordpress uses for links/bookmarks limits the
> length of the description to 255 characters.  The field type used is
> varchar(255).  This can be very restrictive and in our case we really need
> more space available for that field.  I propose changing the field type to
> varchar(0) or some other type that will allow much longer descriptions.
> We could just modify the code or our database for ourselves, but this could
> cause problems if try to restore a backup on a new unmodified installation.
> Also, I don't think space limitations these days really require us to limit
> descriptions to only 255 characters.  Storage is cheap right?
> I have no problem submitting a ticket and patch but I'd like to know what
> other people think and what field type would be recommended.
> Thanks,
> Jared
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers

More information about the wp-hackers mailing list