Binary table default values

Correct MySQL doesn't permit default values for BLOB or TEXT columns. but MySQL has BINARY and VARBINARY types(which support default values), and AR considers them as as type "binary". here is relevant piece of code from schema_definitions.rb,

        def simplified_type(field_type)
          case field_type
            when /int/i
              :integer
            when /float|double/i
              :float
            when /decimal|numeric|number/i
              extract_scale(field_type) == 0 ? :integer : :decimal
            when /datetime/i
              :datetime
            when /timestamp/i
              :timestamp
            when /time/i
              :time
            when /date/i
              :date
            when /clob/i, /text/i
              :text
            when /blob/i, /binary/i
              :binary
            when /char/i, /string/i
              :string
            when /boolean/i
              :boolean
          end
        end

I think its right for AR to consider BINARY and VARBINARY as BINARY type, and utilize methods like string_to_binary with them. The only difference I see is with default values. here is a potential fix for the problem, http://gist.github.com/164981. let me know how it looks and I can create a patch for it.

I'll create a patch for this fix and missing tests for MySQLColumn.

I just realized that the same patch gets applied to 2-3-stable successfully.

(from [5704ecffadffa04981ec5999c362cb691d4a676e]) AR should respect default values for MySQL BINARY and VARBINARY columns.

[#1273 Binary table default values state:committed]

Signed-off-by: Jeremy Kemper jeremy@bitsweat.net
http://github.com/rails/rails/commit/5704ecffadffa04981ec5999c362cb...