Chuck, Maybe it's just me, but I'm not sure what you're asking here.
You wrote: > Hi again i didn't get any feed back regarding MqSql boolean > field/datatype i note that it is evident in version 4.1 my version is > 3.23 ok. http://www.mysql.com/doc/C/o/Column_types.html BIT BOOL CHAR These three are synonyms for CHAR(1). > Plz advice, as there is nothing in the pdf.manual about bool (boolean > true/false values) Only something is regards to MySql keywords bool. > Thus i have used two char's(yes),(no) field types but i would prefer to > use a true/false values. For integers, null is null, 0 is false, anything else is true. > Also is this correct syntax > > create table vol_firstaid ( > vol_firstaid_yes char (yes) , > vol_firstaid_no char (no) ) ; > > currently got the char arguments constraints empty. Are 'yes' and 'no' reserved words? Usually, I think I would put an integer in the parentheses. If I only need the values 'Y' and 'N', then I don't think I would use two fields. You might want to look at the SET and ENUM types (same manual page as above). Or you may just want to use 0 and 1 in a TINYINT field. Depends on what you need. I note that with neither SET nor ENUM can you define 'FALSE' as zero. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka > Come on - let me out of my misery as im a PostgreSql man but like this > tool very much and at the moment creating a work project in both > flavours as back end to out front end internet/intranet proberly Java > ServerPages using DBTags (sql) Jakarta-tomcat v4.02. Thus i need your > advice. > > Cheers Chuck Amadi > Systems Programmer sql, query --------------------------------------------------------------------- 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
