Hi,
to set (RDBMS specific) column attributes in deploy() or
create_ddl_dir() DBIC::ResultSource::add_columns has the "extra"
attribute, e.g. for MySQL:
__PACKAGE__->add_columns(
address => {
data_type => 'varchar',
is_nullable => 0,
default_value => '',
size => '255',
extra => {
mysql_charset => 'utf8',
mysql_collate => 'utf8_bin',
}
);
creates
`address` varchar(255) character set utf8 collate utf8_bin
NOT NULL DEFAULT '',
Nice.
I'm unable to find out, how to set attributes for a table, e.g.
CREATE TABLE `url` (
...
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
("ENGINE=InnoDB" is a default - I want "CHARSET=utf8")
Is that possible in DBIC?
--
Bernhard Graf
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]
