{"action":"created","issue":{"url":"https://api.github.com/repos/alphagov/digitalmarketplace-api/issues/181","labels_url":"https://api.github.com/repos/alphagov/digitalmarketplace-api/issues/181/labels{/name}","comments_url":"https://api.github.com/repos/alphagov/digitalmarketplace-api/issues/181/comments","events_url":"https://api.github.com/repos/alphagov/digitalmarketplace-api/issues/181/events","html_url":"https://github.com/alphagov/digitalmarketplace-api/pull/181","id":95626971,"number":181,"title":"Set Postgres client encoding to UTF8 in config.py.","user":{"login":"RichardKnop","id":2325888,"avatar_url":"https://avatars.githubusercontent.com/u/2325888?v=3","gravatar_id":"","url":"https://api.github.com/users/RichardKnop","html_url":"https://github.com/RichardKnop","followers_url":"https://api.github.com/users/RichardKnop/followers","following_url":"https://api.github.com/users/RichardKnop/following{/other_user}","gists_url":"https://api.github.com/users/RichardKnop/gists{/gist_id}","starred_url":"https://api.github.com/users/RichardKnop/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RichardKnop/subscriptions","organizations_url":"https://api.github.com/users/RichardKnop/orgs","repos_url":"https://api.github.com/users/RichardKnop/repos","events_url":"https://api.github.com/users/RichardKnop/events{/privacy}","received_events_url":"https://api.github.com/users/RichardKnop/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-07-17T10:04:07Z","updated_at":"2015-07-17T12:43:09Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/alphagov/digitalmarketplace-api/pulls/181","html_url":"https://github.com/alphagov/digitalmarketplace-api/pull/181","diff_url":"https://github.com/alphagov/digitalmarketplace-api/pull/181.diff","patch_url":"https://github.com/alphagov/digitalmarketplace-api/pull/181.patch"},"body":"We found out there was an issue with import scripts\r\nnot working properly, we had to set client encoding\r\nin the Postgres connection string in the config file."},"comment":{"url":"https://api.github.com/repos/alphagov/digitalmarketplace-api/issues/comments/122262889","html_url":"https://github.com/alphagov/digitalmarketplace-api/pull/181#issuecomment-122262889","issue_url":"https://api.github.com/repos/alphagov/digitalmarketplace-api/issues/181","id":122262889,"user":{"login":"RichardKnop","id":2325888,"avatar_url":"https://avatars.githubusercontent.com/u/2325888?v=3","gravatar_id":"","url":"https://api.github.com/users/RichardKnop","html_url":"https://github.com/RichardKnop","followers_url":"https://api.github.com/users/RichardKnop/followers","following_url":"https://api.github.com/users/RichardKnop/following{/other_user}","gists_url":"https://api.github.com/users/RichardKnop/gists{/gist_id}","starred_url":"https://api.github.com/users/RichardKnop/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RichardKnop/subscriptions","organizations_url":"https://api.github.com/users/RichardKnop/orgs","repos_url":"https://api.github.com/users/RichardKnop/repos","events_url":"https://api.github.com/users/RichardKnop/events{/privacy}","received_events_url":"https://api.github.com/users/RichardKnop/received_events","type":"User","site_admin":false},"created_at":"2015-07-17T12:43:09Z","updated_at":"2015-07-17T12:43:09Z","body":"```\r\nubuntu@ip-10-128-11-136:~$ psql -U postgres -l\r\n                                                     List of databases\r\n                Name                 |      Owner       | Encoding |   Collate   |    Ctype    |     Access privileges      \r\n-------------------------------------+------------------+----------+-------------+-------------+----------------------------\r\n db_590140734167fd33e6a9             | db_5901407_group | UTF8     | en_US.UTF-8 | en_US.UTF-8 | \r\n digitalmarketplace_api_dbc6b6960938 | digitalmar_group | UTF8     | en_US.UTF-8 | en_US.UTF-8 | \r\n```"}}