Type integer or string: does it matter when querying?

[eluser]jaswinder_rana[/eluser]
char will be faster than varchar. So, i'll go with pyromaniac, unless ofcourse you want to create a table with colors and then use foreign key where you need it.

It really depends on your requirements and how you plan to use it. You have to decide or provide how you plan to use it.

Main difference here is size and ofcourse how often you plan to change data.

This might of interest to you. http://aggregator.foolab.org/node/26143