Some basic stuffs

MySQL & MariaDB Other MySQL® Questions
1

Hi, i have some basic stuffs to ask:

  1. Are there any performance difference in using VARCHAR(255), TEXT , MEDIUMTEXT, LONGTEXT?

I assume if overflow, varchar is the fastest, while the others should be the same, is it correct?

  1. Are there any performance difference between varchar(5) and varchar(255) ? Also assume no overflow, their performance should be the same, right?

Thanks.

2

It is generally a very little difference in speed.
The amount of data (length of string) is so much more significant for the speed so you will not notice any direct difference.

No noticeable difference