I'm afraid enums are useless for anything except compressing your data, since they don't reject bad values. If you want to limit a field to a set of values, you need to use a lookup table and a foreign key constraint.
- Perrin On Fri, Mar 6, 2009 at 1:35 PM, David Karr <davidmichaelk...@gmail.com> wrote: > If I define an enum parameter for a stored program, and the calling code > sends an invalid value, they get the less than useful "data truncated" > error. Is it possible to define the stored program to produce better error > handling for that kind of error? > > This is probably a FAQ, but in general, it appears that error diagnostics in > stored programs are very primitive. Are there any plans in a roadmap to > improve this? > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org