{"action":"created","issue":{"url":"https://api.github.com/repos/amjith/pgcli/issues/134","labels_url":"https://api.github.com/repos/amjith/pgcli/issues/134/labels{/name}","comments_url":"https://api.github.com/repos/amjith/pgcli/issues/134/comments","events_url":"https://api.github.com/repos/amjith/pgcli/issues/134/events","html_url":"https://github.com/amjith/pgcli/issues/134","id":55152049,"number":134,"title":"Cannot handle multibyte characters (ie. Japanese)","user":{"login":"dkastl","id":227762,"avatar_url":"https://avatars.githubusercontent.com/u/227762?v=3","gravatar_id":"","url":"https://api.github.com/users/dkastl","html_url":"https://github.com/dkastl","followers_url":"https://api.github.com/users/dkastl/followers","following_url":"https://api.github.com/users/dkastl/following{/other_user}","gists_url":"https://api.github.com/users/dkastl/gists{/gist_id}","starred_url":"https://api.github.com/users/dkastl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dkastl/subscriptions","organizations_url":"https://api.github.com/users/dkastl/orgs","repos_url":"https://api.github.com/users/dkastl/repos","events_url":"https://api.github.com/users/dkastl/events{/privacy}","received_events_url":"https://api.github.com/users/dkastl/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-01-22T13:19:10Z","updated_at":"2015-01-23T01:27:14Z","closed_at":null,"body":"It seems, that multibyte characters are not supported at all. \r\n\r\nThe following example uses Japanese characters:\r\n\r\nWith PSQL:\r\n\r\n```\r\ntestdb=# SELECT '日本語' AS japanese;\r\n japanese \r\n----------\r\n 日本語\r\n(1 row)\r\n```\r\n\r\nWith PGCLI:\r\n\r\n```\r\ntestdb> SELECT '日本語' AS japanese;\r\n'ascii' codec can't decode byte 0xe6 in position 0: ordinal not in range(128)\r\n```\r\n\r\nYou will receive the same error for every query, that has to deal with a table containing multibyte characters.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/amjith/pgcli/issues/comments/71132996","html_url":"https://github.com/amjith/pgcli/issues/134#issuecomment-71132996","issue_url":"https://api.github.com/repos/amjith/pgcli/issues/134","id":71132996,"user":{"login":"amjith","id":49260,"avatar_url":"https://avatars.githubusercontent.com/u/49260?v=3","gravatar_id":"","url":"https://api.github.com/users/amjith","html_url":"https://github.com/amjith","followers_url":"https://api.github.com/users/amjith/followers","following_url":"https://api.github.com/users/amjith/following{/other_user}","gists_url":"https://api.github.com/users/amjith/gists{/gist_id}","starred_url":"https://api.github.com/users/amjith/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/amjith/subscriptions","organizations_url":"https://api.github.com/users/amjith/orgs","repos_url":"https://api.github.com/users/amjith/repos","events_url":"https://api.github.com/users/amjith/events{/privacy}","received_events_url":"https://api.github.com/users/amjith/received_events","type":"User","site_admin":false},"created_at":"2015-01-23T01:27:14Z","updated_at":"2015-01-23T01:27:14Z","body":"Confirmed that this is a bug. I'll have to drill down and find out where that error is coming from (possibly in psycopg2). \r\n\r\nSorry about the trouble. I'll see if I can fix it soon. \r\n\r\nThank you for reporting. "}}