Possible consequences of increasing varchar length

Question

I'm using an old table, which has a varchar(40) field in it. I want it to be possible to insert more characters in that field, so I want to increase the length of it.
Are there possible negative consequences I should think of before increasing the length?

Answer 1

If you have set the length of 40 but if you try insert more chars, then all will be rejected resulting in empty field value. You should provide the upper length value that you are expected to enter for that field.

Answer 2

Increasing should typically not cause issues, it is the decreasing that can cause problems.

Answer 3

Changing the declared size of a varchar field should not require the existing data to be modified.

Note that changing the size of char or number field will require MySQL to update every affected value to the new type. Changing such fields or adding columns may result in the DBMS having to rewrite the entire table in order to accomodate a larger row size depending on whether there is any redundant space at the row level. This can take some time on a large table.

Make sure that you update any other tables which join to this column too!

HTH

C.