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

[Nirgal <con...@ni...>]

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
>