Color codes

Alec Stewart

15y2.9kSQL

Hi,
I want to know that how can I get the color codes?
Can these codes can be used instead of the color name and how?

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tulasi15y ago
Accepted answer
Hi Alec,

lets see one example of using color codes
Akash Ahlawat15y ago
Its by mistake..
Vulpes15y ago
Placing the question in the 'SQL' category fooled me ;)
Alec Stewart15y ago
Thanks Vidya..
Alec Stewart15y ago
Hi Vulpes,
You took my question in a wrong way..I just want to know that is there any html satatement in which we can use the color code instead of writing color name?
Vulpes15y ago
Are you talking here about storing color data in a SQL database?

If so, then as an alternative to storing a color's name, you could store its RGB hex value instead. For example, here are the codes for the HTML colors:

http://www.w3schools.com/html/html_colornames.asp

This would have the merit of only requiring 3 bytes to store each color.

However, if you wanted to return the color name in a query, you'd have to write a function containing a giant CASE statement to map these hex numbers back to their color names, which isn't very practical.

Frankly, I think it would be easier just to store the name even if it does require more storage.