{"action":"created","issue":{"url":"https://api.github.com/repos/ANXS/postgresql/issues/28","labels_url":"https://api.github.com/repos/ANXS/postgresql/issues/28/labels{/name}","comments_url":"https://api.github.com/repos/ANXS/postgresql/issues/28/comments","events_url":"https://api.github.com/repos/ANXS/postgresql/issues/28/events","html_url":"https://github.com/ANXS/postgresql/pull/28","id":36887565,"number":28,"title":"Don't set client_encoding by default","user":{"login":"gaqzi","id":18167,"avatar_url":"https://avatars.githubusercontent.com/u/18167?v=3","gravatar_id":"","url":"https://api.github.com/users/gaqzi","html_url":"https://github.com/gaqzi","followers_url":"https://api.github.com/users/gaqzi/followers","following_url":"https://api.github.com/users/gaqzi/following{/other_user}","gists_url":"https://api.github.com/users/gaqzi/gists{/gist_id}","starred_url":"https://api.github.com/users/gaqzi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gaqzi/subscriptions","organizations_url":"https://api.github.com/users/gaqzi/orgs","repos_url":"https://api.github.com/users/gaqzi/repos","events_url":"https://api.github.com/users/gaqzi/events{/privacy}","received_events_url":"https://api.github.com/users/gaqzi/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2014-07-01T12:29:17Z","updated_at":"2015-12-14T16:05:08Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/ANXS/postgresql/pulls/28","html_url":"https://github.com/ANXS/postgresql/pull/28","diff_url":"https://github.com/ANXS/postgresql/pull/28.diff","patch_url":"https://github.com/ANXS/postgresql/pull/28.patch"},"body":"The current default value of sql_ascii leaves the database incapable of\r\ninputting Unicode data without first setting the connection encoding. If\r\nthe client_encoding isn't set at all then the client_encoding is set to\r\nthe same as the databases's encoding.\r\n\r\nThe documentation for [client_encoding] isn't super clear I think, but \r\nleaving this value unset would adhere to the default behavior of a \r\nnew installation.\r\n\r\nI don't know if there are more configuration variables that have similar\r\nbehavior as I'm not an experienced Postgresadmin, this was simply one\r\nto bite me. :)\r\n\r\n[client_encoding]: http://www.postgresql.org/docs/9.3/static/runtime-config-client.html#GUC-CLIENT-ENCODING"},"comment":{"url":"https://api.github.com/repos/ANXS/postgresql/issues/comments/164476991","html_url":"https://github.com/ANXS/postgresql/pull/28#issuecomment-164476991","issue_url":"https://api.github.com/repos/ANXS/postgresql/issues/28","id":164476991,"user":{"login":"sebalix","id":5315285,"avatar_url":"https://avatars.githubusercontent.com/u/5315285?v=3","gravatar_id":"","url":"https://api.github.com/users/sebalix","html_url":"https://github.com/sebalix","followers_url":"https://api.github.com/users/sebalix/followers","following_url":"https://api.github.com/users/sebalix/following{/other_user}","gists_url":"https://api.github.com/users/sebalix/gists{/gist_id}","starred_url":"https://api.github.com/users/sebalix/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sebalix/subscriptions","organizations_url":"https://api.github.com/users/sebalix/orgs","repos_url":"https://api.github.com/users/sebalix/repos","events_url":"https://api.github.com/users/sebalix/events{/privacy}","received_events_url":"https://api.github.com/users/sebalix/received_events","type":"User","site_admin":false},"created_at":"2015-12-14T16:05:08Z","updated_at":"2015-12-14T16:05:08Z","body":"This is now fixed, this PR can be closed."}}