Increase Table Rate Shipping of 255 CHAR

[myosc]

Hi,

 

Can anybody tell me how I can increase the shipping table so that it can go and read over the 255 CHAR limit?

 

I looked at my tables, is it in configuration_value that I have to do this at?

 

The limit of 255 is not big enough for all of my needs.

 

Thanks for your help

[yuharry00]

You can alter the column type to any of the following:

 

BLOB

TEXT

 

A BLOB or TEXT column with a maximum length of 65535 (2^16 - 1) characters.

 

MEDIUMBLOB

MEDIUMTEXT

 

A BLOB or TEXT column with a maximum length of 16777215 (2^24 - 1) characters.

 

LONGBLOB

LONGTEXT

 

A BLOB or TEXT column with a maximum length of 4294967295 (2^32 - 1) characters.

 

For example:

alter table configuration modify configuration_value text not null;