Re: [mdb-dev] Memo field with binary data

[Vasilis V. <Vas...@ce...>]

I've inherited the database, and I don't have Office to modify it.
Is there a way to change to avoid the iconv conversion in mdb to access the data as such.

Vasilis

________________________________________
From: Nirgal [con...@ni...]
Sent: 27 August 2011 08:04
To: Vasilis Vlachoudis
Cc: mdb...@li...
Subject: Re: [mdb-dev] Memo field with binary data

mdbtools does not support \0 in memo fields.

mdbtools is using iconv to convert charsets in memo fields, so it will probably destroy your data first anyways.

I wonder how you could put some binary in there by the way. :)

Can you try convert these into Ole/Binary fields first? These should work.


On Thursday 25 August 2011 14:27:10 Vasilis Vlachoudis wrote:
> Hi all,
>
> I have a database that I want to read from linux, in which the Memo field contains variable length binary data actually a list of double precision numbers.
> The problems are:
> 1. The memo is reported with max length of 255, however it contains more than 255 characters.  MS-Access it claims that the Memo can be up to 64k
> 2. Since the memo field contains binary data, it contains also '00'x characters which forces the mdb-export to stop on the first null char, rather dumping the whole string.
>
> How can I extract the binary data (length and actual data) unprocessed so I can access the numbers
>
> Best Regards
> Vasilis
>