I recently took a databases class here at my school, and this argument came up rather heatedly in the class.  The teacher really likes the idea of a char while a few students see no point in it and that varchar are a lot better.  This came up during the group’s presentation to the class on how they were going to design their database.  It really got me thinking which one is better since they both had good arguments behind it.  First, why varchar?

(more…)

char vs varchar · database · type selection