So, I'm building a table to input images.
I have an attribute to enter the caption/description of the image. In some cases, i need just a little more than 255 characters for the caption/description, around 500 and 750 characters... while in most cases 255 characters is just enough.
I'm not sure if I should use varchar(750) or text as the datatype for my caption/description attribute?
I've read the difference between both, but I could never find a clear answer on what is the best solution, performance wise.
Anyone with more knowledge on the issue?
Thanks