[KLUG Members] OpenOffice and mysql

[Mike Williams]

Does anybody have any experience using OpenOffice as a front end for a 
mysql database?  I got them to talk to each other (with 64-bit 
OpenOffice, no less!) through UnixODBC, but I'm having trouble with the 
boolean / bit datatype in mysql.  The problem comes with a NULL value in 
one of the boolean fields.  The OpenOffice interface only shows "true" 
or "not true".  "Not true" includes both "false" and "null", and there's 
no way to tell the difference through that interface.  Talking to mysql 
through the mysql command-line client is just as bad, though.  It only 
shows "null" or "not null", with both "True" and "False" showing up as 
not null (displays as empty space).  So I can get everything to a True 
or False value, but I have to use both interfaces and do things 
manually.  Can anybody suggest another interface to mysql that handles 
bits a little better? Would that be a "bit" better?  Couldn't resist...

If it matters, I'm using mysql 5.0.42 and Openoffice 2.2.1
Thanks.