List MySQL enum in Java

Posted by Pieter on Stack Overflow See other posts from Stack Overflow or by Pieter
Published on 2010-03-12T15:58:18Z Indexed on 2010/03/12 16:07 UTC
Read the original article Hit count: 178

Filed under:

Is there a way to get all possible values from a MySQL enum column?

The MySQL documentation says the MySQL enum type is returned as a Java String, so I basically would like a way to get all possible strings I can pass when querying a table with such an enum.

I couldn't immediately find anything when I was looking through the metadata returned for such a column, but since enum isn't standard SQL, I'm not sure it's even possible... any suggestions?

© Stack Overflow or respective owner

Related posts about java

Related posts about mysql