[wp-hackers] Link Table Description Length

[Jared Havican]

Okay thanks, good to know.  So how about if it was changed to type text(0)
similar to the content of a post/page?

On Mon, Dec 8, 2008 at 6:03 PM, Jason Webster <jason at intraffic.net> wrote:

> 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
>>
>
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>