{"action":"created","issue":{"url":"https://api.github.com/repos/metabase/metabase/issues/2688","repository_url":"https://api.github.com/repos/metabase/metabase","labels_url":"https://api.github.com/repos/metabase/metabase/issues/2688/labels{/name}","comments_url":"https://api.github.com/repos/metabase/metabase/issues/2688/comments","events_url":"https://api.github.com/repos/metabase/metabase/issues/2688/events","html_url":"https://github.com/metabase/metabase/issues/2688","id":157896599,"number":2688,"title":"Add support for the MySql utf8mb4 encoding used for the new 5.7 Json datatype","user":{"login":"anthofo","id":3809685,"avatar_url":"https://avatars.githubusercontent.com/u/3809685?v=3","gravatar_id":"","url":"https://api.github.com/users/anthofo","html_url":"https://github.com/anthofo","followers_url":"https://api.github.com/users/anthofo/followers","following_url":"https://api.github.com/users/anthofo/following{/other_user}","gists_url":"https://api.github.com/users/anthofo/gists{/gist_id}","starred_url":"https://api.github.com/users/anthofo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/anthofo/subscriptions","organizations_url":"https://api.github.com/users/anthofo/orgs","repos_url":"https://api.github.com/users/anthofo/repos","events_url":"https://api.github.com/users/anthofo/events{/privacy}","received_events_url":"https://api.github.com/users/anthofo/received_events","type":"User","site_admin":false},"labels":[{"id":300015465,"url":"https://api.github.com/repos/metabase/metabase/labels/Database/MySQL","name":"Database/MySQL","color":"782E53","default":false},{"id":346586588,"url":"https://api.github.com/repos/metabase/metabase/labels/Help%20Wanted","name":"Help Wanted","color":"fad8c7","default":false},{"id":316506011,"url":"https://api.github.com/repos/metabase/metabase/labels/Limitation","name":"Limitation","color":"CC333F","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2016-06-01T12:40:27Z","updated_at":"2016-12-02T20:00:52Z","closed_at":null,"body":"Hi,\n\nThe new MySql 5.7 Json datatype brings advanced functions for storing and querying json.\nMore info here : https://dev.mysql.com/doc/refman/5.7/en/json.html\n\nThere is an issue with metabase because MySql 5.7 stores Json only in the utf8mb4 encoding (we cannot force it to utf8).\n\nThis encoding is not handled properly by metabase, which breaks the display of json documents containing accentuaded characters.\n\nYou can reproduce the problem by creating a json field and inserting utf8 data into it : \n\n```\nCREATE TABLE t1 (jdoc JSON) CHARACTER SET=utf8 COLLATE=utf8_unicode_ci;\nINSERT INTO t1 VALUES('{\"key1\": \"my value éééàààà\"}');\n```\n\nThen, try to list the content of the table in metabase. You'll see that the encoding is broken.\n"},"comment":{"url":"https://api.github.com/repos/metabase/metabase/issues/comments/264548611","html_url":"https://github.com/metabase/metabase/issues/2688#issuecomment-264548611","issue_url":"https://api.github.com/repos/metabase/metabase/issues/2688","id":264548611,"user":{"login":"camsaul","id":1455846,"avatar_url":"https://avatars.githubusercontent.com/u/1455846?v=3","gravatar_id":"","url":"https://api.github.com/users/camsaul","html_url":"https://github.com/camsaul","followers_url":"https://api.github.com/users/camsaul/followers","following_url":"https://api.github.com/users/camsaul/following{/other_user}","gists_url":"https://api.github.com/users/camsaul/gists{/gist_id}","starred_url":"https://api.github.com/users/camsaul/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/camsaul/subscriptions","organizations_url":"https://api.github.com/users/camsaul/orgs","repos_url":"https://api.github.com/users/camsaul/repos","events_url":"https://api.github.com/users/camsaul/events{/privacy}","received_events_url":"https://api.github.com/users/camsaul/received_events","type":"User","site_admin":false},"created_at":"2016-12-02T20:00:52Z","updated_at":"2016-12-02T20:00:52Z","body":"@sshilko @ravelantunes is talking about how he can't launch Metabase when the backing database is using `utf8mb4` because of size limits on indexed columns. If I remember correctly, those limits were raised in a recent version of MySQL, so the version does matter in his case."}}
{"actor":{"display_login":"camsaul"}}