I'm trying to link ebay rss feeds onto my site.

I've tried xmline and planet but both store the rss line as a 255 varchar unfortunately the rss url from ebay, depending on the search parameters, can be over 300.

The end result is I can only run a rss if the rss url is under 255 characters.

Is it possible to modify the table to accommodate longer rss url's, as the max for varchar is 255
or is there another way of skinning this cat?

An example rss feed I'd like to use is

http://rss.api.ebay.com/ws/rssapi?FeedName=Search
Results&siteId=3&language=en-GB&output=RSS20&copagenum
=1&fss=0&saprclo=&fscl=1ZQ1&fsop=1&fsoo=1&saslop=1&saslt
=2&catref=C6&coaction=compare&sorefinesearch=1&sacur=
0&saaff=afdefault&ftrv=1&ftrt=1&sacat=98952&from=
R10&fcl=3&ga10244=10425&satitle=%28%22sailing+dinghy
%22%2C+cleat%2C+block%2C+pulley%2C+sail%2C+sails%2C+
rope%29+-strand+-rya+-ski+-stainless+-anchor+-mooring
+-yachts+-yacht&saprchi=&coentrypage=search&frpp=200

(I've soft returned the above so it would fit)

some 470 characters long.
the Url is also very long at 517 Characters,

http://search.ebay.co.uk/search/search.dll?sofocus=
bs&sbrftog=1&fcl=3&fss=0&fscl=1&fscl=1&frpp=200&
sorefinesearch=1&catref=C6&saslt=2&sacur=0&from=
R10&saslop=1&saaff=afdefault&satitle=%28%22sailing
+dinghy%22%2C+cleat%2C+block%2C+pulley%2C+sail%2C+
sails%2C+rope%29+-strand+-rya+-ski+-stainless+-
anchor+-mooring+-yachts+-yacht&sacat=98952%26catref%
3DC6&bs=Search&fsop=1%26fsoo%3D1&coaction=
compare&copagenum=1&coentrypage=search&sargn=-
1%26saslc%3D3&sadis=200&fpos=nr34+7hu&ga10244=
10425&ftrt=1&ftrv=1&saprclo=&saprchi=


There must be a reader that can use this rss otherwise why would ebay generate it?

I guess I could put the page in an I-frame but would really like the rss to work.

You have me wondering if it's possible to create usable RSS urls on TinyUrl.com. It may be worth a try.

Another possibility is the new version of the RSS Center .03 module at Happy Linux.

You'll also need to download another module at the site. He's creatively called it the Happy Linux module

Make sure to go through the language files. The developer is a whiz at module creation, but there are quite a few typos.

gestroud you are a complete Star

TinyUrl.com worked a trick,

Happy bunny now