Search code examples
mysqlvarcharlegacy-code

Possible consequences of increasing varchar length in MySql?


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?


Solution

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