Re: Memo field with binary data

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 [[email protected]]
Sent: 25 August 2011 16:27
To: [email protected]
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

------------------------------------------------------------------------------
EMC VNX: the world's simplest storage, starting under $10K
The only unified storage solution that offers unified management 
Up to 160% more powerful than alternatives and 25% more efficient. 
Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev

_______________________________________________
mdbtools-dev mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev