CREATE TABLE i18n ( Id varchar(50), Language char(2), Text text, PRIMARY KEY (Id,Language) ) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci; ; #### package Superclix::Schema::I18N; use strict; use warnings; use base 'DBIx::Class'; __PACKAGE__->load_components(qw(Core UTF8Columns)); __PACKAGE__->table("i18n"); __PACKAGE__->add_columns( "Id" => { data_type => 'VARCHAR', is_nullable => 0, size => 50, accessor => 'name' }, "Language" => { data_type => 'VARCHAR', is_nullable => 0, size => 2, accessor => 'lang' }, "Text" => { data_type => 'TEXT', is_nullable => 0, accessor => 'text' }, ); __PACKAGE__->utf8_columns(qw/Text/); 1;