Public bug reported:
Binary package hint: mdbtools
If the database contains OLE fields, mdb-export will output these as raw
binary, causing character encoding issues, at the very least, and in my
case, unreadable data--the fields are apparently used for replication;
this one is "s_Lineage". Due to some unrelated problems with Access, I
can't remove the fields, so I'm stuck trying to deal with this input
data.
A simple fix is to escape the data in OLE fields as octal bytes, e.g.,
\130 or whatnot. This requires a rather localized change; a patch to do
so (applying to mdb-export.c) is attached. The resultant CSV files now
validate with csv-check from the libtext-csv-xs-perl examples.
Unfortunately, I can't attach the database; I've only been able to
reproduce the problem with a copy of our production data, which (a) is
over 100M, and (b) I'm not privileged to post. But if anyone wants to
attach a database with OLE fields that exports mangled data with the
unpatched version, please feel free.
ProblemType: Bug
Architecture: i386
DistroRelease: Ubuntu 9.04
Package: mdbtools 0.5.99.0.6pre1.0.20051109-4
ProcEnviron:
PATH=(custom, user)
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: mdbtools
Uname: Linux 2.6.28-11-generic i686
** Affects: mdbtools (Ubuntu)
Importance: Undecided
Status: New
** Tags: apport-bug i386
--
mdb-export prints binary for OLE fields.
https://bugs.launchpad.net/bugs/390730
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
