{"action":"created","issue":{"url":"https://api.github.com/repos/Nick-Lucas/LimeBean/issues/27","repository_url":"https://api.github.com/repos/Nick-Lucas/LimeBean","labels_url":"https://api.github.com/repos/Nick-Lucas/LimeBean/issues/27/labels{/name}","comments_url":"https://api.github.com/repos/Nick-Lucas/LimeBean/issues/27/comments","events_url":"https://api.github.com/repos/Nick-Lucas/LimeBean/issues/27/events","html_url":"https://github.com/Nick-Lucas/LimeBean/issues/27","id":165138307,"number":27,"title":"Unicode special characters causing 'Incorrect String value' errors","user":{"login":"Nick-Lucas","id":8896153,"avatar_url":"https://avatars.githubusercontent.com/u/8896153?v=3","gravatar_id":"","url":"https://api.github.com/users/Nick-Lucas","html_url":"https://github.com/Nick-Lucas","followers_url":"https://api.github.com/users/Nick-Lucas/followers","following_url":"https://api.github.com/users/Nick-Lucas/following{/other_user}","gists_url":"https://api.github.com/users/Nick-Lucas/gists{/gist_id}","starred_url":"https://api.github.com/users/Nick-Lucas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Nick-Lucas/subscriptions","organizations_url":"https://api.github.com/users/Nick-Lucas/orgs","repos_url":"https://api.github.com/users/Nick-Lucas/repos","events_url":"https://api.github.com/users/Nick-Lucas/events{/privacy}","received_events_url":"https://api.github.com/users/Nick-Lucas/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-07-12T17:47:28Z","updated_at":"2016-07-14T10:39:46Z","closed_at":null,"body":"The following string threw on `.Store()`\r\n![image](https://cloud.githubusercontent.com/assets/8896153/16777303/dfcea462-4860-11e6-8827-4442d46fe0ff.png)\r\n\r\n![image](https://cloud.githubusercontent.com/assets/8896153/16777339/fb032c08-4860-11e6-99c8-c4a146d8ca48.png)\r\n\r\nData came from a table in utf8 and was being stored to a table of utf8mb4"},"comment":{"url":"https://api.github.com/repos/Nick-Lucas/LimeBean/issues/comments/232629218","html_url":"https://github.com/Nick-Lucas/LimeBean/issues/27#issuecomment-232629218","issue_url":"https://api.github.com/repos/Nick-Lucas/LimeBean/issues/27","id":232629218,"user":{"login":"Nick-Lucas","id":8896153,"avatar_url":"https://avatars.githubusercontent.com/u/8896153?v=3","gravatar_id":"","url":"https://api.github.com/users/Nick-Lucas","html_url":"https://github.com/Nick-Lucas","followers_url":"https://api.github.com/users/Nick-Lucas/followers","following_url":"https://api.github.com/users/Nick-Lucas/following{/other_user}","gists_url":"https://api.github.com/users/Nick-Lucas/gists{/gist_id}","starred_url":"https://api.github.com/users/Nick-Lucas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Nick-Lucas/subscriptions","organizations_url":"https://api.github.com/users/Nick-Lucas/orgs","repos_url":"https://api.github.com/users/Nick-Lucas/repos","events_url":"https://api.github.com/users/Nick-Lucas/events{/privacy}","received_events_url":"https://api.github.com/users/Nick-Lucas/received_events","type":"User","site_admin":false},"created_at":"2016-07-14T10:39:46Z","updated_at":"2016-07-14T10:39:46Z","body":"This is due to the `MariaDbDetails.cs` class in Limebean running  `set names utf8mb4` as recommended here: http://dev.mysql.com/doc/refman/5.7/en/charset-connection.html\r\n\r\nIt seems not to set everything correctly, whereas adding: `characterset=utf8mb4` to the connection string causes this to work. This implied some variable is set by the connection string which is not set by `set names` in MySQL.\r\n\r\nWorkaround is to include the charset this in the connection string"}}
{"actor":{"display_login":"Nick-Lucas"}}