CREATE TABLE i18n ( Id varchar(50), Language char(2), Text text, PRIMARY KEY (Id,Language) ) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci; ;