To use VARCHAR(1000) or LONGTEXT?

Question

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?

http://stackoverflow.com/questions/2023481/mysql-large-varchar-vs-text check this links and this answer too http://stackoverflow.com/a/13182846/552116 — Ghostman, Mar 20 '15 at 04:54

score 1 · Answer 1 · answered Mar 20 '15 at 05:17

1

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

answered Mar 20 '15 at 05:17

Rick James

135,179
13
127
222

To use VARCHAR(1000) or LONGTEXT?

1 Answers1