DROP TABLE IF EXISTS czech_utf8;
CREATE TABLE `czech_utf8` (
      `int_id` int(11) NOT NULL DEFAULT '0',
      `job_id` int(11) NOT NULL DEFAULT '0',
      `code` char(40) NOT NULL,
      PRIMARY KEY (`int_id`),
      UNIQUE KEY `code_ind` (`job_id`,`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO 
  czech_utf8 
VALUES 
  ( 
  1, 
  1, 
  'NA' 
  );

INSERT INTO 
  czech_utf8 
VALUES 
  ( 
  2, 
  1, 
  'NÁ' 
  );