GeorgLedermann wrote:

> Hi,
>
> are there any plans to integrate a new datatype for enumerations
> ("enum") to Firebird?
>
> MySQL has such a datatype (look at
> http://dev.mysql.com/doc/refman/4.1/en/enum.html)and I think it would
> be a great addition for Firebird.

There are number of better ways of doing this that do not build it into
the database in a way that introduces crude limits on function ;)

Martijn has flagged the simple way, and that is one I use when porting
from MySQL to Firebird. The other way of doing it - which allows for
translation of the text - is a simple relational table. The table can
then have multiple languages, and selects the correct one for the client.

ENUM as implemented by MySQL is simply not a good starting point :)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
Treasurer - Firebird Foundation Inc.