Excuse me if this is obvious. I have tried to find an answer to this
problem without luck. A google search does not seem to show this as a
common problem. I have an existing database, with a schema that has
binary columns, and a default value for those columns (in this case
“0000000000000000”).
I am trying to extract the schema using “rake --trace db:schema:dump”,
and am getting the following error:
** Execute db:schema:dump
rake aborted!
binary columns cannot have a default value: “0000000000000000”
Clearly it does not like default binary values; but why is this?
Should I be doing something different in order to hook ROR up to my
existing database?
Thank you Maurício, would you happen to have a suggestion for a
workaround in the mean time?
This is probably an artefact of the fact that mysql blob columns
genuinely cannot have defaults (http://dev.mysql.com/doc/refman/5.0/en/
blob.html). BINARY/VARBINARY columns can, but rails does not
differentiate between binary and blob - it would recreate the column
as a blob and so defaults don’t make sense)
Fred
This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.