MySQL besitzt ein BLOB Type.
Dabei handelt es sich um ein "binary large object".
Damit kannst du Binär Daten in der Datenbank ablegen.

Siehe -> http://www.mysql.com/doc/en/BLOB.html

Gruß, leobm

Moin!

Ich glaube, das Problem ist eher, dass in dem Binary ja auch durchaus Steuerzeichen wie z. B. ' oder \ vorkommen können, die ja auskommentiert werden müssen, damit die Daten erfolgreich eingefügt werden. Leider habe ich von Ruby noch keine Ahnung, aber ich würde es über reguläre Ausdrücke versuchen...

iGEL

Ruby DBI provides a placeholder mechanism that allows you to avoid including data values literally in a query string. Instead, you use special markers within the statement to indicate where the data values go. When you execute the statement, you provide values to be bound to the placeholders. DBI substitutes the values into the statement where the placeholders appear, performing any quoting of string values and escaping of special characters as necessary. This makes it easy to construct statements without having to know whether or not the values contain special characters, and without having to do any quote processing yourself. The placeholder mechanism also properly handles NULL values; just provide nil as a data value and it will be placed into the statement as an unquoted NULL value.

The following example illustrates how this works. Suppose you want to add a new row to the people table for someone named Na'il (a name that includes a quote), who is 76 inches tall. To indicate where the data values go in the INSERT statement, use '?' placeholder markers (without any surrounding quotes), and provide the data values as additional arguments to do following the statement:

dbh.do("INSERT INTO people (id, name, height) VALUES(?, ?, ?)",
nil, "Na'il", 76)The resulting statement produced by do and sent to the server looks like this:
INSERT INTO people (id,name,height) VALUES(NULL,'Na\'il',76)