Store CSS color values in DB

mysql types sqldatatypes
Hommer Smith picture Hommer Smith · Nov 29, 2012 · Viewed 11.2k times · Source

I need to store a CSS HEX color value (#FFFFFF for example) into a mysql database.

Which type of data would I use and why it would be better over using another one?

Answer

silly picture silly · Nov 29, 2012

save the color with a char(6) without the # if the column is not null... if the column is nullable use a varchar(6) to saving size

Related questions

What is the difference between longblob and longtext in mysql?

What is difference between longblob and longtext in mysql? What should I use to save a long topic ?

Read More
What is the datatype to store boolean value in MySQL?

Possible Duplicate: Which MySQL Datatype to use for storing boolean values? I am a .NET programmer and using MySQL database for the first time in my life. I wanted to store boolean value, MySQL has BIT, but the .NET conversion …

Read More
What is the size of column of int(11) in mysql in bytes?

What is the size of column of int(11) in mysql in bytes? And Maximum value that can be stored in this columns?

Read More