0

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?

David542
  • 101,766
  • 154
  • 423
  • 727
  • 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

1 Answers1

1

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

Rick James
  • 122,779
  • 10
  • 116
  • 195