| Subject: | Length of BINARY fields not supported |
If I create a schema with this code:
use Alzabo::Create::Schema;
my $s = Alzabo::Create::Schema->new(name => 'foo', rdbms => 'MySQL' );
my $table = $s->make_table( name => 'some_table' );
my $md5 = $table->make_column(
name => 'checksum',
type => 'binary',
length => 16,
nullable => 0 );
I get the error "BINARY columns cannot have a length or precision."
But the MySQL5.0 doc says: "The BINARY and VARBINARY types are similar to CHAR and VARCHAR, except that they contain binary strings rather than non-binary strings." (http://dev.mysql.com/doc/refman/5.0/en/binary-varbinary.html)
A solution could be to insert a new segment in RDBMSRules::MySQL::validate_colmn_length which validates the BINRAY column_type.