I am working with data that the field values coming into the database might be 0 vs 1, T vs F, or Y vs N, or any combination of these.
Is there a MySQL logical field type that will handle any/all of these at one time? Example: I would like the following data +-------+-------+-------+-------+ | Fld1 | Fld2 | Fld3 | Log | +-------+-------+-------+-------+ | rec1a | rec1b | rec1c | Y | | rec2a | rec2b | rec2c | N | | rec3a | rec3b | rec3c | T | | rec4a | rec4b | rec4c | F | | rec5a | rec5b | rec5c | 0 | | rec6a | rec6b | rec6c | 1 | | rec7a | rec7b | rec7c | False | | rec8a | rec8b | rec8c | True | +-------+-------+-------+-------+ to be stored into a database as: +-------+-------+-------+-----+ | Fld1 | Fld2 | Fld3 | Log | +-------+-------+-------+-----+ | rec1a | rec1b | rec1c | 1 | | rec2a | rec2b | rec2c | 0 | | rec3a | rec3b | rec3c | 1 | | rec4a | rec4b | rec4c | 0 | | rec5a | rec5b | rec5c | 0 | | rec6a | rec6b | rec6c | 1 | | rec7a | rec7b | rec7c | 0 | | rec8a | rec8b | rec8c | 1 | +-------+-------+-------+-----+ ------------------------------------- Lorenzo Curtis Dead River Company --------------------------------------------------------------------- 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
