What's the difference between VARCHAR(255) and TINYTEXT string types in MySQL?


in varchar you have to set the length of a character whereas in tanytext there is nothing like this it saves the memory of data base for ex:
for address you have to define the varchar(50) than your address may be 50 charecter or less the worse condition is your character more than the 50 character this is the limitation of varchar if character is less than 50 than it occupy the 50 character memory in this case memory is increases
so use tanytext it define the character length depend upon the size of character so memory is saved

No comments:

Post a Comment