I have a database which needs a status column updating to a single char status code ('E' or 'U').
I'd like to use an enum for updating this field through my API to ensure the possible values are restricted correctly. Obviously enums can't be of char type. What might be be a good alternative method?
And no, I can't change the database schema :)