{"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":"closed","locked":false,"assignee":null,"milestone":null,"comments":13,"created_at":"2015-01-22T13:19:10Z","updated_at":"2015-01-26T16:46:46Z","closed_at":"2015-01-26T08:19:57Z","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/71492385","html_url":"https://github.com/amjith/pgcli/issues/134#issuecomment-71492385","issue_url":"https://api.github.com/repos/amjith/pgcli/issues/134","id":71492385,"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},"created_at":"2015-01-26T16:46:46Z","updated_at":"2015-01-26T16:46:46Z","body":"Hmm, did not work after upgrading (which required the flag `--force-reinstall` to upgrade).\r\nBut let's see if psycopg2 can provide a solution for this. I don't think hstore support is a blocking issue."}}