[ABE.pm] Storable.pm and MySQL Blobs

[Faber J. Fedor]

Anyone have any experience with these things?

Currently, my app stores data as JSON objects in a mediumtext field in a
MySQL 4.0 database table.  Another application pulls down the data,
translates it back to a Perl hash and off it goes.  It works, but I
think the JSON->hash conversion is too slow.

So I decided to use Storage.pm instead.  I contstruct my SQL stmt just
fine. If I cut and paste a portion of it (the whole stmt is rather large
and unweidly; The portion is half a screen full) in mysql, it works.
However, if I do it from my program, the data that is inserted in
unrecognizeable, i.e. not my data, and far too short, less that ten
characters total.

It seems something is getting lost in... the DBI/DBD call?

-- 
 
Regards,
 
Faber Fedor
President
Linux New Jersey, Inc.
908-320-0357
800-706-0701

http://www.linuxnj.com