title: Encoding problems when importing 23Mb .sql file to MySQL via phpMyAdmin
body: <p>When I import the following .sql file (4 records inserted)</p>
  
  <pre><code>SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  
  CREATE TABLE IF NOT EXISTS `sentences` (
    `jp` text character set utf8 collate utf8_unicode_ci,
    `eng` text character set utf8 collate utf8_unicode_ci,
    `reading` text character set utf8 collate utf8_unicode_ci,
    `query` varchar(50) character set utf8 collate utf8_unicode_ci default NULL,
    `patternIDs` varchar(100) character set utf8 collate utf8_unicode_ci default NULL,
    `hasImage` tinyint(1) NOT NULL,
    `imageURL` varchar(100) character set utf8 collate utf8_unicode_ci NOT NULL,
    `id` int(11) NOT NULL auto_increment,
    PRIMARY KEY  (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=eucjpms;
  
  INSERT INTO `sentences` (`jp`, `eng`, `reading`, `query`, `patternIDs`, `hasImage`, `imageURL`, `id`) VALUES
  ('ムーリエルは２０歳になりました。', 'Muiriel is 20 now.', 'はにぜろさいになりました。', 'ムーリエル', '64', 0, 'none', 1),
  ('すぐに戻ります。', 'I will be back soon.', 'すぐにもどります。', 'すぐ', '4', 1, 'http://ts1.mm.bing.net/images/thumbnail.aspx?q=959017328936&amp;id=b33b9daf539756a8b0b2364f63088008', 2),
  ('すぐに諦めて昼寝をするかも知れない。', 'I may give up soon and just nap instead.', 'すぐにあきらめてひるねをするかもしれない。', '昼寝', '19', 1, 'http://ts1.mm.bing.net/images/thumbnail.aspx?q=888895375610&amp;id=5debb6afed90989674d447f9493b4a1d', 3),
  ('ログアウトするんじゃなかったよ。', 'I shouldn\'t have logged off.', 'ログアウトするんじゃなかったよ。', 'ログアウト', '16', 1, 'http://ts1.mm.bing.net/images/thumbnail.aspx?q=846535990996&amp;id=4e0ad521154e2e7456330af87b24ee71', 4);
  </code></pre>
  
  <p>and then browse the sentences table, all the japanese sentences can be viewed w/o any problems in UTF-8 encoding. However, when I import the following file (exactly the same thing, the only difference in size, ~73000 records inserted, not 4)</p>
  
  <pre><code>SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  
  
      /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
      /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
      /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
      /*!40101 SET NAMES utf8 */;
  
      CREATE TABLE IF NOT EXISTS `sentences` (
        `jp` text character set utf8 collate utf8_unicode_ci,
        `eng` text character set utf8 collate utf8_unicode_ci,
        `reading` text character set utf8 collate utf8_unicode_ci,
        `query` varchar(50) character set utf8 collate utf8_unicode_ci default NULL,
        `patternIDs` varchar(100) character set utf8 collate utf8_unicode_ci default NULL,
        `hasImage` tinyint(1) NOT NULL,
        `imageURL` varchar(100) character set utf8 collate utf8_unicode_ci NOT NULL,
        `id` int(11) NOT NULL auto_increment,
        PRIMARY KEY  (`id`)
      ) ENGINE=MyISAM  DEFAULT CHARSET=eucjpms;
  
      INSERT INTO `sentences` (`jp`, `eng`, `reading`, `query`, `patternIDs`, `hasImage`, `imageURL`, `id`) VALUES
      ('ムーリエルは２０歳になりました。', 'Muiriel is 20 now.', 'はにぜろさいになりました。', 'ムーリエル', '64', 0, 'none', 1),
      ('すぐに戻ります。', 'I will be back soon.', 'すぐにもどります。', 'すぐ', '4', 1, 'http://ts1.mm.bing.net/images/thumbnail.aspx?q=959017328936&amp;id=b33b9daf539756a8b0b2364f63088008', 2),
      ('すぐに諦めて昼寝をするかも知れない。', 'I may give up soon and just nap instead.', 'すぐにあきらめてひるねをするかもしれない。', '昼寝', '19', 1, 'http://ts1.mm.bing.net/images/thumbnail.aspx?q=888895375610&amp;id=5debb6afed90989674d447f9493b4a1d', 3),
      ('ログアウトするんじゃなかったよ。', 'I shouldn\'t have logged off.', 'ログアウトするんじゃなかったよ。', 'ログアウト', '16', 1, 'http://ts1.mm.bing.net/images/thumbnail.aspx?q=846535990996&amp;id=4e0ad521154e2e7456330af87b24ee71', 4)
  ('先生に質問したら、すぐに答えてくれました。', 'When I asked a question to my teacher, he/she immediately answered it.', 'せんせいにしつもんしたら、すぐにこたえてくれました。', '先生', '64, 189', 1, 'http://ts1.mm.bing.net/images/thumbnail.aspx?q=889488746606&amp;id=53a411907232964b30b9ebde03093a66', 73660),
  ('薬を飲んだら、すぐになおりました。', 'I took a medicine, and soon recovered.', 'くすりをのんだら、すぐになおりました。', '薬', '19, 64, 189', 1, 'http://ts2.mm.bing.net/images/thumbnail.aspx?q=934254550695&amp;id=4400863ae021a4827dd7f9f7380fc2a2', 73661);
  </code></pre>
  
  <p>I can't see Japanese characters. Why is that? Why does phpMyAdmin have encoding problems when importing bigger .sql files? Thanks, guys!</p>