MySQL Forums :: Performance :: CHAR vs VARCHAR


Advanced Search

CHAR vs VARCHAR
Posted by: Weydson Lima ()
Date: October 12, 2010 10:08AM

I had two columns defined as VARCHAR(50). At that time, I ran the procedure analyze feature and suggested me that I changed them to CHAR(50). However, I created some indexes on these columns. When I reran the procedure analyze, it suggests that I go back with VARCHAR.

My thinking was that CHAR is better than VARCHAR because it's a fixed-size column. I am not worried about disk space - which VARCHAR would win in this case I believe. My only concern is about the performance.

Options: ReplyQuote


Subject Views Written By Posted
CHAR vs VARCHAR 4502 Weydson Lima 10/12/2010 10:08AM
Re: CHAR vs VARCHAR 1565 Rick James 10/13/2010 05:54PM
Re: CHAR vs VARCHAR 1164 Shantanu Oak 11/02/2010 01:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.