SQL query to insert binary data using Ruby

Question

I'm trying to insert some binary data into database using 'mysql' gem in ruby. But as the binary data contains many single and double quotes, the following code fails. Please help me to fix it.

m = mysql.prepare("insert into data (binary) values ('#{binary_data}') ")

Error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.......' at line 1 (Mysql::Error)

Haim Evgi · Accepted Answer · 2012-04-01 06:48:33Z

2

binary is reserved word in mysql so wrap it with apostrophe like

insert into data (`binary`) ......

edited Apr 1, 2012 at 6:48

answered Apr 1, 2012 at 6:43

Haim Evgi

126k46 gold badges222 silver badges227 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sergio Tulentsev · Accepted Answer · 2012-04-01 06:42:11Z

1

You're using prepared statements wrong. What about this?

stmnt = mysql.prepare("insert into data (`binary`) values (?)")
stmnt.execute binary

answered Apr 1, 2012 at 6:42

Sergio Tulentsev

231k43 gold badges381 silver badges373 bronze badges

Collectives™ on Stack Overflow

SQL query to insert binary data using Ruby

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related