Insert blob - rails 1.0.0 mysql 3.23 - sql syntax error


Experimenting with upload and insert a picture into a MySQL database -
Agile Web D. with Rails p362-3.

We have rails 1.0.0 and MySQL 3.23.58.

I get an error
‘You have an error in your SQL syntax near’
because rails uses the x’ffdbff…’ notation for the blob which is not
available until MySQL 4

Is there a way of switching Rails to use the 0xffdbff… notation?


Chris Sendall
University of Cambridge

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs