Ann Myhre wrote:

>Hi group
>
>Access has a datatype (I don't remember the name) which is a kind of boleaen; it 
>represents Yes/No, true or false. When I try to translate that creating a table in 
>MySQL I try ENUM("N","Y") but I do not get the expected result when using If Y 
>then...(ASP). Do I use ENUM right? I have tried SET also, but with no better result.
>Anyone?
>

Use type `bool'. This is an alias for tinyint(1), with values 0 or 1.

Charlie






---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

  • enum Peter Adamka
    • Enum Ann Myhre
      • Charlie Harrison

Reply via email to