Michael Dykman wrote:
I hope I'm not opening an old can of worms here, but there are some
design trade-offs in this decision. ENUM has the strong advantage of
being able to constrain the contents to the specific expected values.
It is not possible for an application insert an illegal value wherea
<[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, July 30, 2004 12:48 PM
> Subject: Enum or Int
>
>
> > Hello all
> >
> > I have a table with a field which needs to hold a yes/no or 1/0 value.
> >
> > Which field type is best for t
Salzgeber Olivier" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 30, 2004 12:48 PM
Subject: Enum or Int
> Hello all
>
> I have a table with a field which needs to hold a yes/no or 1/0 value.
>
> Which field type is best for this ?
> Should i create
Hello all
I have a table with a field which needs to hold a yes/no or 1/0 value.
Which field type is best for this ?
Should i create a ENUM field with yes or no values or is it better to create
an Int field for this ?
What would you recommend ?
Best regards
Olivier Salzgeber
--
MySQL General