{"action":"created","issue":{"url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/51","repository_url":"https://api.github.com/repos/laurenz/oracle_fdw","labels_url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/51/labels{/name}","comments_url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/51/comments","events_url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/51/events","html_url":"https://github.com/laurenz/oracle_fdw/issues/51","id":129919658,"number":51,"title":"invalid byte sequence for encoding \"UTF8\": 0xe3 0x4e 0x9c","user":{"login":"bartonjd","id":1497522,"avatar_url":"https://avatars.githubusercontent.com/u/1497522?v=3","gravatar_id":"","url":"https://api.github.com/users/bartonjd","html_url":"https://github.com/bartonjd","followers_url":"https://api.github.com/users/bartonjd/followers","following_url":"https://api.github.com/users/bartonjd/following{/other_user}","gists_url":"https://api.github.com/users/bartonjd/gists{/gist_id}","starred_url":"https://api.github.com/users/bartonjd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bartonjd/subscriptions","organizations_url":"https://api.github.com/users/bartonjd/orgs","repos_url":"https://api.github.com/users/bartonjd/repos","events_url":"https://api.github.com/users/bartonjd/events{/privacy}","received_events_url":"https://api.github.com/users/bartonjd/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/laurenz/oracle_fdw/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":9,"created_at":"2016-01-30T00:35:47Z","updated_at":"2016-02-22T17:26:33Z","closed_at":null,"body":"I am trying to select a varchar field from my foreign data wrapper and keep getting the error:\r\ninvalid byte sequence for encoding \"UTF8\": 0xe3 0x4e 0x9c\r\nCONTEXT:  converting column \"spbpers_ssn\" for foreign table scan of \"spbpers\", row 1\r\n\r\nI managed to add an elog command to the oracle_fdw and determined that this is the value that is being returned by oracle:▒N▒/u▒▒O8▒▒ΰ▒U▒▒▒2▒▒ ▒▒_+S\r\n\r\nMy best guess is that the company that produced the software which created the table has it set for encryption at rest? When I query in sqlplus I am able to see the column values just fine but in postgres everything I have tried fails. Every other field in the table works. Any thoughts?"},"comment":{"url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/comments/187279079","html_url":"https://github.com/laurenz/oracle_fdw/issues/51#issuecomment-187279079","issue_url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/51","id":187279079,"user":{"login":"bartonjd","id":1497522,"avatar_url":"https://avatars.githubusercontent.com/u/1497522?v=3","gravatar_id":"","url":"https://api.github.com/users/bartonjd","html_url":"https://github.com/bartonjd","followers_url":"https://api.github.com/users/bartonjd/followers","following_url":"https://api.github.com/users/bartonjd/following{/other_user}","gists_url":"https://api.github.com/users/bartonjd/gists{/gist_id}","starred_url":"https://api.github.com/users/bartonjd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bartonjd/subscriptions","organizations_url":"https://api.github.com/users/bartonjd/orgs","repos_url":"https://api.github.com/users/bartonjd/repos","events_url":"https://api.github.com/users/bartonjd/events{/privacy}","received_events_url":"https://api.github.com/users/bartonjd/received_events","type":"User","site_admin":false},"created_at":"2016-02-22T17:26:33Z","updated_at":"2016-02-22T17:26:33Z","body":"Unfortunately my employer will not allow me to disclose that as it is\nsomewhat sensitive :/\n\nOn Mon, Feb 22, 2016 at 8:58 AM, Laurenz Albe <notifications@github.com>\nwrote:\n\n> Thanks!\n>\n> Can you tell me the CREATE TABLE and CREATE FOREIGN TABLE statements used\n> to create these tables?\n>\n> —\n> Reply to this email directly or view it on GitHub\n> <https://github.com/laurenz/oracle_fdw/issues/51#issuecomment-187243382>.\n>\n"}}