{"action":"created","issue":{"url":"https://api.github.com/repos/crystal-lang/crystal-mysql/issues/46","repository_url":"https://api.github.com/repos/crystal-lang/crystal-mysql","labels_url":"https://api.github.com/repos/crystal-lang/crystal-mysql/issues/46/labels{/name}","comments_url":"https://api.github.com/repos/crystal-lang/crystal-mysql/issues/46/comments","events_url":"https://api.github.com/repos/crystal-lang/crystal-mysql/issues/46/events","html_url":"https://github.com/crystal-lang/crystal-mysql/issues/46","id":249520456,"number":46,"title":"Connect to database with collation/character other than UTF8","user":{"login":"kazzkiq","id":1953194,"avatar_url":"https://avatars1.githubusercontent.com/u/1953194?v=4","gravatar_id":"","url":"https://api.github.com/users/kazzkiq","html_url":"https://github.com/kazzkiq","followers_url":"https://api.github.com/users/kazzkiq/followers","following_url":"https://api.github.com/users/kazzkiq/following{/other_user}","gists_url":"https://api.github.com/users/kazzkiq/gists{/gist_id}","starred_url":"https://api.github.com/users/kazzkiq/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kazzkiq/subscriptions","organizations_url":"https://api.github.com/users/kazzkiq/orgs","repos_url":"https://api.github.com/users/kazzkiq/repos","events_url":"https://api.github.com/users/kazzkiq/events{/privacy}","received_events_url":"https://api.github.com/users/kazzkiq/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2017-08-11T01:45:38Z","updated_at":"2017-10-08T15:30:54Z","closed_at":null,"author_association":"NONE","body":"In some cases other collations are needed in order to accept [Emojis and/or non-latin](https://stackoverflow.com/questions/35125933/mysql-utf8mb4-errors-when-saving-emojis) characters.\r\n\r\nIt seems that as of today, this project do not provide a way to connect to MySQL database with any other option than UTF8, which leads to database errors when trying to add those \"special\" new characters.\r\n\r\nWith the wide use of smartphones, its basically impossible to build any application that do not support emojis. Its used anywhere, and its popularizing even more each year, so I believe the project should support some way to handle this."},"comment":{"url":"https://api.github.com/repos/crystal-lang/crystal-mysql/issues/comments/335014461","html_url":"https://github.com/crystal-lang/crystal-mysql/issues/46#issuecomment-335014461","issue_url":"https://api.github.com/repos/crystal-lang/crystal-mysql/issues/46","id":335014461,"user":{"login":"crisward","id":3109157,"avatar_url":"https://avatars0.githubusercontent.com/u/3109157?v=4","gravatar_id":"","url":"https://api.github.com/users/crisward","html_url":"https://github.com/crisward","followers_url":"https://api.github.com/users/crisward/followers","following_url":"https://api.github.com/users/crisward/following{/other_user}","gists_url":"https://api.github.com/users/crisward/gists{/gist_id}","starred_url":"https://api.github.com/users/crisward/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/crisward/subscriptions","organizations_url":"https://api.github.com/users/crisward/orgs","repos_url":"https://api.github.com/users/crisward/repos","events_url":"https://api.github.com/users/crisward/events{/privacy}","received_events_url":"https://api.github.com/users/crisward/received_events","type":"User","site_admin":false},"created_at":"2017-10-08T15:30:54Z","updated_at":"2017-10-08T15:30:54Z","author_association":"CONTRIBUTOR","body":"Something like this give us the correct settings for the database.\r\n\r\n`SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME\r\nFROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'db_name'`\r\n\r\nWe just then need to convert the names to the correct bytes."}}
{"actor":{"display_login":"crisward"}}