It's not a secret anymore!
The moose likes Other Languages and the fly likes Rails MySQL BLOB support Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Languages » Other Languages
Bookmark "Rails MySQL BLOB support" Watch "Rails MySQL BLOB support" New topic

Rails MySQL BLOB support

Ernest Friedman-Hill
author and iconoclast

Joined: Jul 08, 2003
Posts: 24193

Took this MySQL amateur more than an hour of Googling to find out that the reason file upload to a MySQL BLOB in Rails (see p. 362 in "Agile Web Development with Rails) wasn't working was that Rails only works with MySQL BLOBs in MySQL 4 and later. Nothing ever checks for the MySQL version, the book never mentions this, the Rails site doesn't mention this, that I can see... Just an ugly "Bad SQL syntax" failure.

This wouldn't be a big problem except that some very common Linux distros come with MySQL 3.x by default -- Fedora Core 3 being one of them most relevant to me. Grrrrrr. I hate wasted time.

[Jess in Action][AskingGoodQuestions]
Lasse Koskela

Joined: Jan 23, 2002
Posts: 11962
I feel your pain, Ernest.

Are you on #rubyonrails, by the way? The #rubyonrails IRC channel (at, port 6667) is a pretty good forum for getting quick answers to small questions...

Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]
I agree. Here's the link:
subject: Rails MySQL BLOB support
It's not a secret anymore!