Ubuntu
libreoffice package

  1. Bug #1086357
  2. Comment #6

Comment 6 for bug 1086357

Revision history for this message
Allan Kelly (wolasallank) wrote :

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.