Comment 0 for bug 1086357

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

After changing from using ODBC to MySQL Connector extension to connect to MySQL databases, I noticed some columns defined as Bit fields did not behave correctly. Field data would not modify.

Editing the tables in Libreoffice I have found that columns which are defined as Bit in MySQL are shown as Field Type text VARCHAR .

Ubuntu 12.04
libreoffice 1:3.5.4-0ubuntu1.1 (LibreOffice 3.5.4.2 Build ID: 350m1(Build:2))
libreoffice-mysql-connector 1.0.1+LibO3.5.4-0ubuntu1.1
mysql-client 5.5.28-0ubuntu0.12.04.2
mysql-server 5.5.28-0ubuntu0.12.04.2