I think the real answer is to define a concise list of allowable colors. You would then require data entry to pick from that list, no exceptions. I've noticed that this is what my state does. Put something odd on your app and it comes back as a more generic color.
Dennis McGrath
