VB: VB: [mdb-dev] Patches for reading binary columns and supressing newlines

[Hans-Emil S. <Han...@tr...>]

I have talked with Stephen J. Gowdy of the list. (He requested the =
possibility to read binary fields on the list about two months ago =
http://sourceforge.net/mailarchive/message.php?msg_id=3D12733896 .)

Below is the result of his testing of the read binary patch.

Who would be responsible for reviewing and accepting patches for the =
CVS-sources?

Hans-Emil

-----Ursprungligt meddelande-----
Fr=E5n: Stephen J. Gowdy [mailto:go...@sl...]=20
Skickat: den 31 oktober 2005 19:08
Till: Hans-Emil Skogh
=C4mne: Re: VB: [mdb-dev] Patches for reading binary columns and =
supressing newlines

Hi Hans-Emil,
	Yeah, works fine;

[antonia] ~/unix/PE3ToKimdaba > echo select fFolderInfoArray from =
ImageTable where fImageOriginalFileName =3D \'img_0521.jpg\' | mdb-sql =
-HF -p photos.mdb
DC0600005D0000001D0000001B00000000000000000000000000000000000000000000000=
0000000000000000000000000000000000000000000000000000000000000000000000000=
0000000000000000000000000000000000000000000000000000000000000000000000000=
0000000000000000000000000000000000000000000000000000000000000000000000000=
0000000000000000000000000000000000000000000000000000000000000000000000000=
0000000000000000000000000000000000000000000000000000000000000000000000000=
0000000000000000000000000000000000000000000000000000000000000000000000000=
0000000000000000000000000000000000000000000000000000000000000000000000000=
0000000000000000000000000000000000000000000000000000000000000000000000000=
0000000000000000000000000000000000000000000000000000000000000000000000000=
0000000000000000000000000000000000000000000000000000000000000000000000

	I'm not subscribed to the list so I can't reply to your message,
unless you can bounce it to me?

							regards,

							Stephen.

On Mon, 31 Oct 2005, Hans-Emil Skogh wrote:

> Sorry. Seems like SF does not archive attachments. Here are both the =
patches.
>
>
>
> Hope it works better this time around. :-)
>
>
>
> Hans-Emil
>
>
>
> ________________________________
>
> Fr=E5n: mdb...@li... =
[mailto:mdb...@li...] F=F6r Hans-Emil Skogh
> Skickat: den 26 oktober 2005 17:05
> Till: mdb...@li...
> =C4mne: [mdb-dev] Patches for reading binary columns and supressing =
newlines
>
>
>
> Hi!
>
>
>
> I have created two patches for MDBTools. Both are reliant on that =
Pedro A. Aranda's patch =
(http://sourceforge.net/mailarchive/forum.php?thread_id=3D8498445&forum_i=
d=3D5183) is applied to make the mdb-sql tool work again. (Apply it with =
the -R switch.)
>
> sql-read-binary.patch
> Enables mdb-sql to read and output Access binary fields. This is vital =
to access for example Adobe Photoshop Elements 3-databases. The binary =
data is outputted as hex values. In pretty print the length is =
truncated.
>
> sql-strip-newlines.patch
> Adds a parameter -s to mdb-sql that replaces all newline characters =
with spaces when not in pretty-print mode. This is very valuable when =
using the output from mdb-sql in a script.
>
> The sql-read-binary patch has parts from Philip Gladstone's binary =
patch =
(http://sourceforge.net/tracker/index.php?func=3Ddetail&aid=3D876414&grou=
p_id=3D2294&atid=3D302294)
>
> It would be nice if both patches (and Pedros!) could be added to the =
CVS source tree.
>
> Hans-Emil
>

--
 /------------------------------------+-------------------------\
|Stephen J. Gowdy                     | SLAC, MailStop 34,       |
|http://www.slac.stanford.edu/~gowdy/ | 2575 Sand Hill Road,     |
|http://calendar.yahoo.com/gowdy      | Menlo Park CA 94025, USA |
|EMail: go...@sl...       | Tel: +1 650 926 3144     |
 \------------------------------------+-------------------------/