At 12:34 -0700 7/9/03, Dan Kroymann wrote:
>Is there anyway to retrieve the list of valid values for an enumerated
>type column via JDBC? I read through the documentation on JDBC and the
>source code for Connector/J, and as far as I can tell it's not possible
>due to the fact that MySQL's ENUM type is not a part of the SQL
>standard.


The list is part of the output from SHOW COLUMNS FROM tbl_name, but
you must parse it apart yourself.

>
>Hoping someone can prove me wrong,
>Dan Kroymann
>
>
>--
>MySQL Java Mailing List
>For list archives: http://lists.mysql.com/java
>To unsubscribe: http://lists.mysql.com/java?unsub=paul@mysql.com



--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

Are you MySQL certified? http://www.mysql.com/certification/


--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe: http://lists.mysql.com/java?unsub=my...ie.nctu.edu.tw