{"action":"created","issue":{"url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/6461","repository_url":"https://api.github.com/repos/salesagility/SuiteCRM","labels_url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/6461/labels{/name}","comments_url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/6461/comments","events_url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/6461/events","html_url":"https://github.com/salesagility/SuiteCRM/pull/6461","id":376278813,"node_id":"MDExOlB1bGxSZXF1ZXN0MjI3NTMxODgy","number":6461,"title":"Allow database character set configuration","user":{"login":"dominicchinkh","id":32015447,"node_id":"MDQ6VXNlcjMyMDE1NDQ3","avatar_url":"https://avatars3.githubusercontent.com/u/32015447?v=4","gravatar_id":"","url":"https://api.github.com/users/dominicchinkh","html_url":"https://github.com/dominicchinkh","followers_url":"https://api.github.com/users/dominicchinkh/followers","following_url":"https://api.github.com/users/dominicchinkh/following{/other_user}","gists_url":"https://api.github.com/users/dominicchinkh/gists{/gist_id}","starred_url":"https://api.github.com/users/dominicchinkh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dominicchinkh/subscriptions","organizations_url":"https://api.github.com/users/dominicchinkh/orgs","repos_url":"https://api.github.com/users/dominicchinkh/repos","events_url":"https://api.github.com/users/dominicchinkh/events{/privacy}","received_events_url":"https://api.github.com/users/dominicchinkh/received_events","type":"User","site_admin":false},"labels":[{"id":1148555079,"node_id":"MDU6TGFiZWwxMTQ4NTU1MDc5","url":"https://api.github.com/repos/salesagility/SuiteCRM/labels/Community%20Contribution","name":"Community Contribution","color":"108bb5","default":false},{"id":332488472,"node_id":"MDU6TGFiZWwzMzI0ODg0NzI=","url":"https://api.github.com/repos/salesagility/SuiteCRM/labels/Wrong%20Branch","name":"Wrong Branch","color":"e6e6e6","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2018-11-01T07:08:31Z","updated_at":"2018-12-06T01:37:54Z","closed_at":null,"author_association":"NONE","pull_request":{"url":"https://api.github.com/repos/salesagility/SuiteCRM/pulls/6461","html_url":"https://github.com/salesagility/SuiteCRM/pull/6461","diff_url":"https://github.com/salesagility/SuiteCRM/pull/6461.diff","patch_url":"https://github.com/salesagility/SuiteCRM/pull/6461.patch"},"body":"Allow database character set configuration\r\n\r\n## Description\r\nSuiteCRM administrator can configure \"dbconfigoption\" as below in config_override.php file so that the MySQL database support storing four bytes per character.\r\n\r\n$sugar_config['dbconfigoption']['collation'] = 'utf8mb4_unicode_ci';\r\n$sugar_config['dbconfigoption']['charset'] = 'utf8mb4';\r\n\r\n## Motivation and Context\r\nMySQL's encoding called \"utf8\" (alias of \"utf8mb3\") only stores a maximum of three bytes per code point. SuiteCRM users often copy and paste text which may include emoji or unicode characters into SuiteCRM text field. This change supports storing supplemental characters in MySQL database. \r\n\r\n## How To Test This\r\n(1) Delete the config.php file. Reinstall the MySQL database\r\n(2) Add a new relationship in Studio\r\n\r\n## Types of changes\r\n- [] Bug fix (non-breaking change which fixes an issue)\r\n- [X] New feature (non-breaking change which adds functionality)\r\n- [ ] Breaking change (fix or feature that would cause existing functionality to change)\r\n\r\n### Final checklist\r\n- [X] My code follows the code style of this project found [here](https://docs.suitecrm.com/community/contributing-code/coding-standards/).\r\n- [ ] My change requires a change to the documentation.\r\n- [X] I have read the [**How to Contribute**](https://docs.suitecrm.com/community/contributing-code/) guidelines.\r\n"},"comment":{"url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/comments/444716441","html_url":"https://github.com/salesagility/SuiteCRM/pull/6461#issuecomment-444716441","issue_url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/6461","id":444716441,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0NDcxNjQ0MQ==","user":{"login":"dominicchinkh","id":32015447,"node_id":"MDQ6VXNlcjMyMDE1NDQ3","avatar_url":"https://avatars3.githubusercontent.com/u/32015447?v=4","gravatar_id":"","url":"https://api.github.com/users/dominicchinkh","html_url":"https://github.com/dominicchinkh","followers_url":"https://api.github.com/users/dominicchinkh/followers","following_url":"https://api.github.com/users/dominicchinkh/following{/other_user}","gists_url":"https://api.github.com/users/dominicchinkh/gists{/gist_id}","starred_url":"https://api.github.com/users/dominicchinkh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dominicchinkh/subscriptions","organizations_url":"https://api.github.com/users/dominicchinkh/orgs","repos_url":"https://api.github.com/users/dominicchinkh/repos","events_url":"https://api.github.com/users/dominicchinkh/events{/privacy}","received_events_url":"https://api.github.com/users/dominicchinkh/received_events","type":"User","site_admin":false},"created_at":"2018-12-06T01:37:54Z","updated_at":"2018-12-06T01:37:54Z","author_association":"NONE","body":"Hi,\nI have changed branch to develop from master.\n\nRegards,\nDominic\n\nOn Tue, 4 Dec. 2018, 7:30 pm Ashley Nicolson <notifications@github.com\nwrote:\n\n> Hi @dominicchinkh <https://github.com/dominicchinkh>! Thanks for your\n> (multiple) contributions! Can you change the base branch to develop than\n> master as we don't directly merge into master. I'm asking for develop as we\n> are in the midst of a major release so getting it in develop would be\n> quicker than hotfix at the moment.\n>\n> —\n> You are receiving this because you were mentioned.\n> Reply to this email directly, view it on GitHub\n> <https://github.com/salesagility/SuiteCRM/pull/6461#issuecomment-444013787>,\n> or mute the thread\n> <https://github.com/notifications/unsubscribe-auth/AeiEV_Uj3rG4JCeyQxkdcB1LWfiDUfxFks5u1jKWgaJpZM4YF5Pd>\n> .\n>\n"}}
{"actor":{"display_login":"dominicchinkh"}}