mysql> SELECT id, wikidata_id, senkyoku_id FROM `candidates` WHERE `candidates`.`senkyoku_id` = 321;
+-----+-------------+-------------+
| id  | wikidata_id | senkyoku_id |
+-----+-------------+-------------+
| 388 | Q7497524    |         321 |
+-----+-------------+-------------+
1 row in set (0.01 sec)

mysql> select * from senkyokus where pref_code = 23 and senkyoku_no = 11;
+-----+-----------+-------------+----------+---------------------+---------------------+
| id  | pref_code | senkyoku_no | zip_code | created_at          | updated_at          |
+-----+-----------+-------------+----------+---------------------+---------------------+
| 321 | 23        |          11 | 471      | 2017-10-09 10:59:29 | 2017-10-09 10:59:29 |
| 323 | 23        |          11 | 473      | 2017-10-09 10:59:29 | 2017-10-09 10:59:29 |
+-----+-----------+-------------+----------+---------------------+---------------------+
2 rows in set (0.01 sec)

$ bundle exec rake graydb:import
["UI用DBカラム名", "name_full", "name_last", "name_first", "name_alias", "name_full_furigana", "pary_id", nil, "party_history", "is_candidate", "current_position", "submission_order", nil, "pref_code", "senkyoku_no", "hirei_area_id", nil, "candidacy_history", "winning_history", "gender", "birth_day", nil, "birth_year", "photo_url", "twitter_id", "facebook_id", "facebook_page_id", "line_id", "youtube_channel_id", "instagram_id", "offiicial_website_url", "email", "official_blog_url", "reference_url", "birth_place", "educational_background", nil, "occupation", "position_held", "father", "spouse", nil, "url_wikidata", "url_wikipedia", nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil]

Mysql2::Error: Incorrect string value: '\xF0\xA5\x99\xBF' for column 'name_first' at row 1: INSERT INTO `candidates` (`name_first`, `name_last`, `name_first_furigana`, `name_last_furigana`, `party_id`, `gender`, `birth_day`, `birth_year`, `official_website_url`, `created_at`, `updated_at`, `wikidata_id`, `is_candidate`, `current_position`, `winning_history`, `hirei_area_id`) VALUES ('𥙿', '森山', 'ひろし', 'もりやま', 12, 1, '1945-04-08', 1945, 'http://www.moriyama-hiroshi.jp/', '2017-10-12 14:45:44', '2017-10-12 14:45:44', 'Q337762', 1, 1, '1975年鹿児島市議会議員補欠選挙\n第18回参議院議員通常選挙\n2004年衆議院鹿児島5区補欠選挙\n第44回衆議院議員総選挙\n第45回衆議院議員総選挙\n第46回衆議院議員総選挙\n第47回衆議院議員総選挙', 11)
#<ActiveModel::Errors:0x007fb2ba350c68 @base=#<Candidate id: nil, name_first: "𥙿", name_last: "森山", name_first_furigana: "ひろし", name_last_furigana: "もりやま", party_id: 12, senkyoku_id: nil, gender: 1, birth_day: "1945-04-08", birth_year: 1945, twitter_id: nil, facebook_id: nil, official_website_url: "http://www.moriyama-hiroshi.jp/", photo_url: nil, created_at: "2017-10-12 14:45:44", updated_at: "2017-10-12 14:45:44", wikidata_id: "Q337762", is_candidate: true, current_position: 1, submission_order: nil, winning_history: "1975年鹿児島市議会議員補欠選挙\n第18回参議院議員通常選挙\n2004年衆議院鹿児島5区補欠選挙\n...", hirei_area_id: 11>, @messages={}, @details={}>

00:45 deploy:migrating
      01 /var/www/codeforelection_front/rvm1scripts/rvm-auto.sh 2.4.2 bundle ex…
      01 rake aborted!
      01 StandardError: An error has occurred, all later migrations canceled:
      01
      01 Mysql2::Error: Duplicate entry '13-1' for key 'index_senkyokus_on_pref…

mysql> show variables like "chara%";
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | latin1                     |
| character_set_connection | latin1                     |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | latin1                     |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       | 
| character_set_connection | utf8                       | 
| character_set_database   | utf8                       | 
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

[mysqld]
character-set-server=utf8

[client]
default-character-set=utf8