All geek questions in one place

Possible consequences of increasing varchar length in MySql?

I am using an old table that has a varchar (40) field in it. I want it possible to insert more characters into this field, so I want to increase its length.
Are there any possible negative consequences that I must consider before increasing the length?

+3
source share
3 answers

An increase, if usually not a problem, is a decrease that can cause problems.

+4
source

Changing the declared size of the varchar field does not require changing existing data.

, char number MySQL . , , , . .

, , !

.

+3

40, , , . , .

-2

Source: https://habr.com/ru/post/1729201/

More articles:


All Articles