Since 2012 I have worked around this issue by using ODBC to connect to MySQL from LibreOffice.
However I have now upgraded to Ubuntu 16.04 which no longer has the ODBC package libmyodbc so I have had to revert to the mysql connector to allow connecting tC MySQL tables using LibreOffice Base Columns defined Bit(1) in MySQL still show incorrectly as VarChar in LibreOffice Base and cannot be maintained via LibreOffice Base. I have found a workable alternative. In Base, if I edit the table column and change the column type Yes/No Boo, the table column type updates to TinyInt. The column still provides the flag capability in my queries and can now be updated in Base via Tables or Forms. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1086357 Title: Bit Fields appear as Varchar using libreoffice-mysqlconnector To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1086357/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs