{"action":"created","issue":{"url":"https://api.github.com/repos/onyxfish/csvkit/issues/199","labels_url":"https://api.github.com/repos/onyxfish/csvkit/issues/199/labels{/name}","comments_url":"https://api.github.com/repos/onyxfish/csvkit/issues/199/comments","events_url":"https://api.github.com/repos/onyxfish/csvkit/issues/199/events","html_url":"https://github.com/onyxfish/csvkit/issues/199","id":9822808,"number":199,"title":"csvsql codec can't encode character","user":{"login":"vegetable21","id":3158859,"avatar_url":"https://avatars.githubusercontent.com/u/3158859?v=3","gravatar_id":"","url":"https://api.github.com/users/vegetable21","html_url":"https://github.com/vegetable21","followers_url":"https://api.github.com/users/vegetable21/followers","following_url":"https://api.github.com/users/vegetable21/following{/other_user}","gists_url":"https://api.github.com/users/vegetable21/gists{/gist_id}","starred_url":"https://api.github.com/users/vegetable21/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vegetable21/subscriptions","organizations_url":"https://api.github.com/users/vegetable21/orgs","repos_url":"https://api.github.com/users/vegetable21/repos","events_url":"https://api.github.com/users/vegetable21/events{/privacy}","received_events_url":"https://api.github.com/users/vegetable21/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/onyxfish/csvkit/labels/bug","name":"bug","color":"e10c02"},{"url":"https://api.github.com/repos/onyxfish/csvkit/labels/Low%20Priority","name":"Low Priority","color":"c7def8"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2013-01-09T21:58:31Z","updated_at":"2015-07-05T07:42:58Z","closed_at":"2014-09-20T00:32:25Z","body":"similar to (or the same as) issue #82 i get this issue on 0.5.0\r\nto recreate use the following dataset: \r\nhttp://www.education.gov.uk/schools/performance/download/csv/england_spine.csv\r\n\r\nusage:\r\ncsvsql --db \"mysql://user:pass@localhost/db\" --table \"spine\" --insert -e \"utf8\" england_spine.csv\r\n\r\nerror:\r\n'latin-1' codec can't encode character u'\\u2013' in position 12: ordinal not in range(256)\r\n\r\nam i missing something? the file passes csvcut and csvstat just fine but the encoding appears to revert to 'latin-1' one when writing to the db"},"comment":{"url":"https://api.github.com/repos/onyxfish/csvkit/issues/comments/118593328","html_url":"https://github.com/onyxfish/csvkit/issues/199#issuecomment-118593328","issue_url":"https://api.github.com/repos/onyxfish/csvkit/issues/199","id":118593328,"user":{"login":"ObsidianX","id":96612,"avatar_url":"https://avatars.githubusercontent.com/u/96612?v=3","gravatar_id":"","url":"https://api.github.com/users/ObsidianX","html_url":"https://github.com/ObsidianX","followers_url":"https://api.github.com/users/ObsidianX/followers","following_url":"https://api.github.com/users/ObsidianX/following{/other_user}","gists_url":"https://api.github.com/users/ObsidianX/gists{/gist_id}","starred_url":"https://api.github.com/users/ObsidianX/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ObsidianX/subscriptions","organizations_url":"https://api.github.com/users/ObsidianX/orgs","repos_url":"https://api.github.com/users/ObsidianX/repos","events_url":"https://api.github.com/users/ObsidianX/events{/privacy}","received_events_url":"https://api.github.com/users/ObsidianX/received_events","type":"User","site_admin":false},"created_at":"2015-07-05T07:42:58Z","updated_at":"2015-07-05T07:42:58Z","body":"Just so it can be noted for future users running into this:\r\n\r\nSQLAlchemy can take in an encoding on the DB URL:\r\n\r\n`mysql://localhost/dbname?charset=utf8`"}}