From: Peter Cooper <peter@...>
Date: 2007-06-25T09:16:03+09:00
Subject: Re: insert marshall'd data into mysql

On 6/25/07, Aaron Smith <beingthexemplary@gmail.com> wrote:
> Hey all.. what methods can I use to safely insert Ruby marshall'd data
> into mysql?

Use a BLOB column. MySQL treats BLOB columns as 8 bit binary data.
TEXT will also work, but there are a number of considerations (
http://dev.mysql.com/doc/refman/5.0/en/blob.html ). Since Marshalled
data is just regular 8 bit data, you can just throw it in there. If
you were /really/ worried / paranoid about throwing full 8 bit data,
non printable characters and all, into a database, you could Base64
encode and decode.

Cheers,
Peter Cooper
http://www.rubyinside.com/