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
How can I modify an existing column's data type?

One of the columns in a somewhat large table (~10,000 records) is of the data type DECIMAL(10,0). I'm using MySQL. I'd like the values to be displayed to 2 decimal places, so I need to alter this to DECIMAL(10,2), without screwing up …

Read More