Page 1 of 1
Type question.
Posted: Thu Sep 27, 2012 9:04 am
by social_experiment
Poor choice for a subject line but i hope my question explains it better. If i have a field with the type varchar 20 and the values inserted into the table are not always 20 characters long, will this cause any problems in terms of performance when retrieving the data?
Re: Type question.
Posted: Thu Sep 27, 2012 1:18 pm
by Christopher
I doubt anything noticeable. I recall researching the performance difference between CHAR and VARCHAR in MySQL. I think maybe long ago there was a difference in databases, but I don't think there is any difference anymore. Maybe someone has some definitive information.
Re: Type question.
Posted: Thu Sep 27, 2012 3:24 pm
by Benjamin
No it's padded I believe in the data files anyway to a fixed length.