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

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

Hi all,

looking in the source code of mdblib I saw that the column->len_ptr holds the length of the object, then modifying a bit the mdb-export.c to dump *(col->len_ptr) characters I correctly the memo fields in some of the rows, but it fails completely in some other rows.
When it fails it report smaller size e.g 521 instead of 2336.

>From which variable I can get the correct MEMO size?

Vasilis
________________________________
From: Vasilis Vlachoudis [Vas...@ce...]
Sent: 25 August 2011 16:27
To: mdb...@li...
Subject: [mdb-dev] Memo field with binary data

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