Reputation: 28187

Will extending the size of a varchar field in MySQL affect the data thats inside it?

I am going to be extending the column from VARCHAR(350) to VARCHAR(800) - will affect any of the strings that are inside the column already?

Upvotes: 2

Answers (3)

Reputation: 6450

No you're fine with that

Upvotes: 0

Reputation: 212522

No, it will only affect new data inserted/updated after you've made the change by allowing you to change or add new values up to the new length

Upvotes: 1

Reputation: 10176

Expanding, no.

Shrinking, yes.

Upvotes: 6