CODEWITHSUNDEEP
mysql
David542
David542

Reputation: 110502

To use VARCHAR(1000) or LONGTEXT?

What is the difference in using a very large VARCHAR field or using a LONGTEXT field? At which point, would it be advantageous to start using a LONGTEXT over VARCHAR?

Upvotes: 0

Views: 575

Answers (1)

Rick James
Rick James

Reputation: 142528

Once you are past about 512 characters, there is no practical difference between VARCHAR and TEXT. (TEXT gives you a max of 64K.)

Upvotes: 1

Related Questions