| 2012-12-08 01:37:23 |
Allan Kelly |
description |
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 |
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
---
ApportVersion: 2.0.1-0ubuntu15
Architecture: amd64
DistroRelease: Ubuntu 12.04
InstallationMedia: Ubuntu 12.04 LTS "Precise Pangolin" - Release amd64 (20120425)
MarkForUpload: True
NonfreeKernelModules: nvidia
Package: libreoffice 1:3.5.4-0ubuntu1.1
PackageArchitecture: amd64
ProcEnviron:
LANGUAGE=en_GB:en
TERM=xterm
PATH=(custom, no user)
LANG=en_GB.UTF-8
SHELL=/bin/bash
ProcVersionSignature: Ubuntu 3.2.0-34.53-generic 3.2.33
Tags: precise running-unity
Uname: Linux 3.2.0-34-generic x86_64
UpgradeStatus: No upgrade log present (probably fresh install)
UserGroups: |
|
