{"action":"created","issue":{"url":"https://api.github.com/repos/coleifer/peewee/issues/178","repository_url":"https://api.github.com/repos/coleifer/peewee","labels_url":"https://api.github.com/repos/coleifer/peewee/issues/178/labels{/name}","comments_url":"https://api.github.com/repos/coleifer/peewee/issues/178/comments","events_url":"https://api.github.com/repos/coleifer/peewee/issues/178/events","html_url":"https://github.com/coleifer/peewee/issues/178","id":12616910,"number":178,"title":"Change default charset in MySql's create table statements","user":{"login":"ibraaaa","id":4008455,"avatar_url":"https://avatars.githubusercontent.com/u/4008455?v=3","gravatar_id":"","url":"https://api.github.com/users/ibraaaa","html_url":"https://github.com/ibraaaa","followers_url":"https://api.github.com/users/ibraaaa/followers","following_url":"https://api.github.com/users/ibraaaa/following{/other_user}","gists_url":"https://api.github.com/users/ibraaaa/gists{/gist_id}","starred_url":"https://api.github.com/users/ibraaaa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ibraaaa/subscriptions","organizations_url":"https://api.github.com/users/ibraaaa/orgs","repos_url":"https://api.github.com/users/ibraaaa/repos","events_url":"https://api.github.com/users/ibraaaa/events{/privacy}","received_events_url":"https://api.github.com/users/ibraaaa/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2013-03-29T19:58:13Z","updated_at":"2016-07-15T13:47:53Z","closed_at":"2013-03-30T03:03:11Z","body":"For MySql, when I try to insert text encoded in utf8 into a table, the text is scrambled. The issue is that the default charset for tables is latin1, to fix this I need to ALTER a table after its creation to change the charset. Providing such option from inside peewee will be helpful."},"comment":{"url":"https://api.github.com/repos/coleifer/peewee/issues/comments/232955141","html_url":"https://github.com/coleifer/peewee/issues/178#issuecomment-232955141","issue_url":"https://api.github.com/repos/coleifer/peewee/issues/178","id":232955141,"user":{"login":"coleifer","id":119974,"avatar_url":"https://avatars.githubusercontent.com/u/119974?v=3","gravatar_id":"","url":"https://api.github.com/users/coleifer","html_url":"https://github.com/coleifer","followers_url":"https://api.github.com/users/coleifer/followers","following_url":"https://api.github.com/users/coleifer/following{/other_user}","gists_url":"https://api.github.com/users/coleifer/gists{/gist_id}","starred_url":"https://api.github.com/users/coleifer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/coleifer/subscriptions","organizations_url":"https://api.github.com/users/coleifer/orgs","repos_url":"https://api.github.com/users/coleifer/repos","events_url":"https://api.github.com/users/coleifer/events{/privacy}","received_events_url":"https://api.github.com/users/coleifer/received_events","type":"User","site_admin":false},"created_at":"2016-07-15T13:47:53Z","updated_at":"2016-07-15T13:47:53Z","body":"You can also:\r\n```\r\ndb = MySQLDatabase(...)\r\ndb.execute_sql(\"SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci;\")\r\n```\r\n\r\nBeyond that I'm not familiar enough with MySQL to be able to advise you what parameters or settings to modify. Consult the docs or try stackoverflow if you are still stuck."}}
{"actor":{"display_login":"coleifer"}}