I have two columns that can be long, but 99% of times will be short (less than 255 characters). This means that I can not use VARCHAR(255) because 1% of times I could not save data. I thought to make them TEXT type, but I read here https://stackoverflow.com/questions/44493446/mysql-is-it-a-good-practice-to-use-text-datatype-to-nullable-fields that TEXT slow down queries performance on that table.
If I make both columns VARCHAR(5000) instead of TEXT, would it have a negative performance impact on queries on that table anyway?
VARCHAR(255)
columns then, if needed.