Increase Manufacturer URL Character Count

Hello everyone!
In Catalog > Manufacturers, by editing a particural manufacturer, you can set a Manufacturer's url. The character limit for that field is 255.
Can that be increased?
If yes, then how?

Many thanks for reading this!

you can set a Manufacturer's url. The character limit for that field is 255.
Who has a url that exceeds 255???

But that is in the database but not sure that you can increase it

kobra:

Who has a url that exceeds 255???

But that is in the database but not sure that you can increase it

Hi Cobra, thanks for replying.
I'm not using the field for the url, but rather for inputing text.

Yes, I'm talking about the database entry for manufacturer's url, I want to increase that from 255 characters to let's say 1000 and I don't know how.

I believe that the code makes this a clickable link
So using it for text might not be a prudent move

kobra:

I believe that the code makes this a clickable link
So using it for text might not be a prudent move

Indeed you are correct, but I have taken precaution to remove the hyperlink.
So now the question remains: how do I increase the 255 character limit for the database?
:cheers:

Use something like phpmyadmin browse that table and that record

manufacturers_info > manufacturers_url
You will need to change the class of the manufacturers_url entry from varchar(255) to text

Or if using mysql 5.x can increase the carchar
Prior to MySQL 5, the max VARCHAR was 255. Now VARCHAR can get up around 65k

kobra:

Use something like phpmyadmin browse that table and that record

manufacturers_info > manufacturers_url
You will need to change the class of the manufacturers_url entry from varchar(255) to text

Or if using mysql 5.x can increase the carchar
Prior to MySQL 5, the max VARCHAR was 255. Now VARCHAR can get up around 65k

Thanks for the pointers.
As I am using mysql 5+, I've used the following statement with success:

ALTER TABLE manufacturers_info MODIFY manufacturers_url VARCHAR(1000);