Retrieving enum information
Hi,
I'm using the MySqlDataReader object to get information from a DB after sending a select query. I need to find out which columns are returned and the myReader.GetDataTypeName(int) works fine. However, some columns might be of the ENUM type. For that I have 2 questions:
1. How do I check whether or not a column is of enum type?
2. How do I retrieve all valid entries for an enum column? In a given retrieved relation, only the values 'red' and 'blue' might appear, but I need to know what other types are valid. F.g 'orange'.
Any help is greatly appreciated.