{"action":"reopened","issue":{"url":"https://api.github.com/repos/jam-py/jam-py/issues/16","repository_url":"https://api.github.com/repos/jam-py/jam-py","labels_url":"https://api.github.com/repos/jam-py/jam-py/issues/16/labels{/name}","comments_url":"https://api.github.com/repos/jam-py/jam-py/issues/16/comments","events_url":"https://api.github.com/repos/jam-py/jam-py/issues/16/events","html_url":"https://github.com/jam-py/jam-py/issues/16","id":182725001,"number":16,"title":"'ascii' codec can't encode with Oracle (UTF8 problem)","user":{"login":"dbabicwa","id":9026100,"avatar_url":"https://avatars.githubusercontent.com/u/9026100?v=3","gravatar_id":"","url":"https://api.github.com/users/dbabicwa","html_url":"https://github.com/dbabicwa","followers_url":"https://api.github.com/users/dbabicwa/followers","following_url":"https://api.github.com/users/dbabicwa/following{/other_user}","gists_url":"https://api.github.com/users/dbabicwa/gists{/gist_id}","starred_url":"https://api.github.com/users/dbabicwa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dbabicwa/subscriptions","organizations_url":"https://api.github.com/users/dbabicwa/orgs","repos_url":"https://api.github.com/users/dbabicwa/repos","events_url":"https://api.github.com/users/dbabicwa/events{/privacy}","received_events_url":"https://api.github.com/users/dbabicwa/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-10-13T08:23:01Z","updated_at":"2016-11-03T07:05:37Z","closed_at":null,"body":"Hi \n\nafter successful import to Oracle I am using ISO88592 language and UTF8 and got similar error with both when creating new records:\n\n'ascii' codec can't encode character u'\\u0160' in position 0: ordinal not in range(128)\n\nMy Oracle language settings:\nNLS_CHARACTERSET AL32UTF8\nNLS_LANGUAGE AMERICAN\n\nLinux server using:\n env |grep LAN\nLANG=en_AU.UTF-8\nLANGUAGE=en_AU:en\n\nThe data is looking ok in the database when viewing with SqlDeveloper (imported csv's as task.copy_database doesn't work). But the appl is not displaying it right.\n\nThe Sqlplus is not showing right as well.\n\nThe solution is to set the Oracle NLS variable on Linux before running jam server:\n\nexport NLS_LANG=AMERICAN_AMERICA.UTF8\n\nSqlplus is showing now data correctly, for example:\nselect lastname from DEMO_CUSTOMERS;\n## LASTNAME\n\nGonçalves\nKöhler\nTremblay\nHansen\nWichterlová\nHolý\n\nEverything else seems to be working really well Andrew!  \n\nHope this helps!\n\nD.\n[orig_1.3.45_4.0.24_2016-10-13_15-33-45.zip](https://github.com/jam-py/jam-py/files/526488/orig_1.3.45_4.0.24_2016-10-13_15-33-45.zip)\n"}}
{"actor":{"display_login":"jam-py"}}