[Ruby-DBI-devel] Storing Binary Data....

[Sean C. <se...@ch...>]

How is it possible to store binary data in PostgreSQL via DBI?  When I
insert binary data (ex: Marhsal.dump({"uga"=>"booga"})) into the
database, it escapes the data improperly.  I'm storing the data in a
bytea column type.

Before insert:	"\004\a{\006\"\010uga\"\nbooga"
After insert:	"\\004\\007{\\006\"\\010uga\"\\012booga"

Needless to say the two strings aren't the same.  Anyone have any
ideas as to why this is happening and how I can get around this?  When
inserting into a bytea column, DBI seems to be doing too much
work.  -sc


-- 
Sean Chittenden