{"action":"created","issue":{"url":"https://api.github.com/repos/mozilla/build-relengapi/issues/330","labels_url":"https://api.github.com/repos/mozilla/build-relengapi/issues/330/labels{/name}","comments_url":"https://api.github.com/repos/mozilla/build-relengapi/issues/330/comments","events_url":"https://api.github.com/repos/mozilla/build-relengapi/issues/330/events","html_url":"https://github.com/mozilla/build-relengapi/pull/330","id":104273126,"number":330,"title":"Set and verify MySQL connection charset","user":{"login":"djmitche","id":28673,"avatar_url":"https://avatars.githubusercontent.com/u/28673?v=3","gravatar_id":"","url":"https://api.github.com/users/djmitche","html_url":"https://github.com/djmitche","followers_url":"https://api.github.com/users/djmitche/followers","following_url":"https://api.github.com/users/djmitche/following{/other_user}","gists_url":"https://api.github.com/users/djmitche/gists{/gist_id}","starred_url":"https://api.github.com/users/djmitche/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/djmitche/subscriptions","organizations_url":"https://api.github.com/users/djmitche/orgs","repos_url":"https://api.github.com/users/djmitche/repos","events_url":"https://api.github.com/users/djmitche/events{/privacy}","received_events_url":"https://api.github.com/users/djmitche/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/mozilla/build-relengapi/labels/r?","name":"r?","color":"FFFFFF"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-09-01T13:59:41Z","updated_at":"2015-09-01T14:43:30Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/mozilla/build-relengapi/pulls/330","html_url":"https://github.com/mozilla/build-relengapi/pull/330","diff_url":"https://github.com/mozilla/build-relengapi/pull/330.diff","patch_url":"https://github.com/mozilla/build-relengapi/pull/330.patch"},"body":"This will at least catch the case where the client charset is `latin1`.\r\n\r\n(the PR will reduce coverage since we don't test against MySQL in Travis)"},"comment":{"url":"https://api.github.com/repos/mozilla/build-relengapi/issues/comments/136746357","html_url":"https://github.com/mozilla/build-relengapi/pull/330#issuecomment-136746357","issue_url":"https://api.github.com/repos/mozilla/build-relengapi/issues/330","id":136746357,"user":{"login":"djmitche","id":28673,"avatar_url":"https://avatars.githubusercontent.com/u/28673?v=3","gravatar_id":"","url":"https://api.github.com/users/djmitche","html_url":"https://github.com/djmitche","followers_url":"https://api.github.com/users/djmitche/followers","following_url":"https://api.github.com/users/djmitche/following{/other_user}","gists_url":"https://api.github.com/users/djmitche/gists{/gist_id}","starred_url":"https://api.github.com/users/djmitche/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/djmitche/subscriptions","organizations_url":"https://api.github.com/users/djmitche/orgs","repos_url":"https://api.github.com/users/djmitche/repos","events_url":"https://api.github.com/users/djmitche/events{/privacy}","received_events_url":"https://api.github.com/users/djmitche/received_events","type":"User","site_admin":false},"created_at":"2015-09-01T14:43:30Z","updated_at":"2015-09-01T14:43:30Z","body":"Setting the variables doesn't help, since MySQLdb doesn't know about the changes.\r\n\r\nCalling `dbapi_con.set_charset(\"utf8\")` works, but it's fairly specific to MySQLdb.\r\n\r\nThis option, adding `charset=utf8` to the URL, works and seems fairly generic."}}