Mike, I'm using the mySQL Query Browser (on Windows 2K), and I used BIT(1) fields all the time. The default value field in this tool accepts 0 or 1 - not b'0' or b'1'. Try this with your tool.
At 08:55 PM 2007-03-29 -0400, you wrote: >I'm setting up a field in a MySQL5 table and trying to use the bit type, >with a default of b'1' -- however, my UI tool (SQLYog5) does not like me >trying to give a default value of b'1' . Am I doing it wrong? >According to >http://dev.mysql.com/doc/refman/5.1/en/bit-field-values.html, it looks >like my notation should be correct? > >In MySQL4, I had been using tinyint(1) with the value being either 1/0, >equivalent to VFP's logical fields. I was giving bit a shot, but my >plan B is to go back to using tinyint(1). > >Ideas? tia! >--Michael > >-- >Michael J. Babcock, MCP >MB Software Solutions, LLC >http://mbsoftwaresolutions.com >http://fabmate.com >"Work smarter, not harder, with MBSS custom software solutions!" > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
