barfoon
barfoon

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

Views: 329

Answers (3)

Brian
Brian

Reputation: 6450

No you're fine with that

Upvotes: 0

Mark Baker
Mark Baker

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

Nick DeVore
Nick DeVore

Reputation: 10176

Expanding, no.

Shrinking, yes.

Upvotes: 6

Related Questions