{"action":"closed","issue":{"url":"https://api.github.com/repos/alberanid/imdbpy/issues/37","repository_url":"https://api.github.com/repos/alberanid/imdbpy","labels_url":"https://api.github.com/repos/alberanid/imdbpy/issues/37/labels{/name}","comments_url":"https://api.github.com/repos/alberanid/imdbpy/issues/37/comments","events_url":"https://api.github.com/repos/alberanid/imdbpy/issues/37/events","html_url":"https://github.com/alberanid/imdbpy/issues/37","id":187501420,"number":37,"title":"Importing to Sql Server - text has encoding issues","user":{"login":"ericpopivker","id":245515,"avatar_url":"https://avatars.githubusercontent.com/u/245515?v=3","gravatar_id":"","url":"https://api.github.com/users/ericpopivker","html_url":"https://github.com/ericpopivker","followers_url":"https://api.github.com/users/ericpopivker/followers","following_url":"https://api.github.com/users/ericpopivker/following{/other_user}","gists_url":"https://api.github.com/users/ericpopivker/gists{/gist_id}","starred_url":"https://api.github.com/users/ericpopivker/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ericpopivker/subscriptions","organizations_url":"https://api.github.com/users/ericpopivker/orgs","repos_url":"https://api.github.com/users/ericpopivker/repos","events_url":"https://api.github.com/users/ericpopivker/events{/privacy}","received_events_url":"https://api.github.com/users/ericpopivker/received_events","type":"User","site_admin":false},"labels":[{"id":348634741,"url":"https://api.github.com/repos/alberanid/imdbpy/labels/sql","name":"sql","color":"d4c5f9","default":false}],"state":"closed","locked":false,"assignee":{"login":"alberanid","id":222857,"avatar_url":"https://avatars.githubusercontent.com/u/222857?v=3","gravatar_id":"","url":"https://api.github.com/users/alberanid","html_url":"https://github.com/alberanid","followers_url":"https://api.github.com/users/alberanid/followers","following_url":"https://api.github.com/users/alberanid/following{/other_user}","gists_url":"https://api.github.com/users/alberanid/gists{/gist_id}","starred_url":"https://api.github.com/users/alberanid/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alberanid/subscriptions","organizations_url":"https://api.github.com/users/alberanid/orgs","repos_url":"https://api.github.com/users/alberanid/repos","events_url":"https://api.github.com/users/alberanid/events{/privacy}","received_events_url":"https://api.github.com/users/alberanid/received_events","type":"User","site_admin":false},"assignees":[{"login":"alberanid","id":222857,"avatar_url":"https://avatars.githubusercontent.com/u/222857?v=3","gravatar_id":"","url":"https://api.github.com/users/alberanid","html_url":"https://github.com/alberanid","followers_url":"https://api.github.com/users/alberanid/followers","following_url":"https://api.github.com/users/alberanid/following{/other_user}","gists_url":"https://api.github.com/users/alberanid/gists{/gist_id}","starred_url":"https://api.github.com/users/alberanid/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alberanid/subscriptions","organizations_url":"https://api.github.com/users/alberanid/orgs","repos_url":"https://api.github.com/users/alberanid/repos","events_url":"https://api.github.com/users/alberanid/events{/privacy}","received_events_url":"https://api.github.com/users/alberanid/received_events","type":"User","site_admin":false}],"milestone":null,"comments":1,"created_at":"2016-11-05T14:54:41Z","updated_at":"2016-11-13T10:50:02Z","closed_at":"2016-11-13T10:50:02Z","body":"Hi,\r\n\r\nThank you very much for a great tool.\r\n\r\nI am using it to import latest IMDB csv files to local Sql Server Express 2014 database.\r\nWhen I look at the data in DB I see text like this in title.title.:\r\n\r\n\"A PrÃ³xima VÃ­tima\"\r\n\"DiscriminaciÃ³n en el lenguaje\"\r\n...\r\n\r\nIn name.name  I see,\r\n\r\n\"Aarseth, Ã˜ystein\"\r\n\"Abati, JoÃ«l\"\r\n...\r\n\r\nLooks like something with encoding.  The command I use to import is:\r\npython.exe imdbpy2sql.py-d C:\\imdb-files -u \"mssql://connection text\" --ms-sqlserver\r\n\r\nI am using Sql Server 2014 express.\r\nWhat can I do to fix it?\r\n\r\nThank you,\r\n\r\nEric\r\n\r\n"}}
{"actor":{"display_login":"alberanid"}}