How to change 255 character limit on all rss url aggregator field?

By jt6919 on 8 Aug 2006 at 00:49 UTC

I have tons of aggregator feeds I need to add that are all greater than the 255 characters allowed for feed url's in the database. The URL aggregator field is varchar 255, how can you change it to a larger number without breaking anything?

Comments

mysql 4.x max length is 255

VM commented 8 August 2006 at 03:38

mysql 4.x max length is 255 if you are running mysql 5.0.3 or higher maximum is 65K and change.

That said, unless you are running mysql 5.0.3 or higher, you cannot increase beyond 255.

why not??

jt6919 commented 8 August 2006 at 03:46

why can't you make it a blob??

tried to change, but...

jt6919 commented 8 August 2006 at 15:24

I tried to change the field in the myPHPAdmin from varchar 255 to blob, but it said couldn't because the "url" field was some kind of key or something. My version of mysql isn't changing anytime soon, so can anyone tell me how to modify the URL field to accept more than 255 characters without screwing up the database?