Increase Manufacturer URL Character Count

[kidsstuff]

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!

[kobra]

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

[kidsstuff]

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.

[kobra]

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

[kidsstuff]

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?

[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