{"action":"created","issue":{"url":"https://api.github.com/repos/joomla-projects/com_localise/issues/286","repository_url":"https://api.github.com/repos/joomla-projects/com_localise","labels_url":"https://api.github.com/repos/joomla-projects/com_localise/issues/286/labels{/name}","comments_url":"https://api.github.com/repos/joomla-projects/com_localise/issues/286/comments","events_url":"https://api.github.com/repos/joomla-projects/com_localise/issues/286/events","html_url":"https://github.com/joomla-projects/com_localise/pull/286","id":141309771,"number":286,"title":"Support utf8mb4 in com_localise component","user":{"login":"andrepereiradasilva","id":9630530,"avatar_url":"https://avatars.githubusercontent.com/u/9630530?v=3","gravatar_id":"","url":"https://api.github.com/users/andrepereiradasilva","html_url":"https://github.com/andrepereiradasilva","followers_url":"https://api.github.com/users/andrepereiradasilva/followers","following_url":"https://api.github.com/users/andrepereiradasilva/following{/other_user}","gists_url":"https://api.github.com/users/andrepereiradasilva/gists{/gist_id}","starred_url":"https://api.github.com/users/andrepereiradasilva/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andrepereiradasilva/subscriptions","organizations_url":"https://api.github.com/users/andrepereiradasilva/orgs","repos_url":"https://api.github.com/users/andrepereiradasilva/repos","events_url":"https://api.github.com/users/andrepereiradasilva/events{/privacy}","received_events_url":"https://api.github.com/users/andrepereiradasilva/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":28,"created_at":"2016-03-16T15:30:33Z","updated_at":"2016-03-17T12:07:15Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/joomla-projects/com_localise/pulls/286","html_url":"https://github.com/joomla-projects/com_localise/pull/286","diff_url":"https://github.com/joomla-projects/com_localise/pull/286.diff","patch_url":"https://github.com/joomla-projects/com_localise/pull/286.patch"},"body":"#### Description\r\n\r\nThis PR is for adding utf8mb4 support to com_localise.\r\n\r\nA develop package and a patched utf8mb4 develop package has been created for the tests.\r\n- [com_localise-develop.zip](https://github.com/joomla-projects/com_localise/files/176567/com_localise-develop.zip)\r\n- [com_localise-develop-utf8mb4.zip](https://github.com/joomla-projects/com_localise/files/176570/com_localise-develop-utf8mb4.zip)\r\n\r\n\r\n\r\n#### How to test\r\n\r\n##### New install\r\n\r\n1. Install utf8mb4 develop package from URL (https://github.com/joomla-projects/com_localise/files/176570/com_localise-develop-utf8mb4.zip)\r\n2. Check in phpmyadmin if `#__localise` and `#__localise_revised_values` tables collations are now utf8mb4_unicode_ci\r\n3. Check if everything is working fine.\r\n\r\n##### Update\r\n\r\n1. If not yet, install develop package without utf8mb4 com_localise from URL (https://github.com/joomla-projects/com_localise/files/176567/com_localise-develop.zip)\r\n2. Update com_localise from URL to the utf8mb4 version (https://github.com/joomla-projects/com_localise/files/176570/com_localise-develop-utf8mb4.zip)\r\n3. Check in phpmyadmin if `#__localise` and `#__localise_revised_values` tables collations are now utf8mb4_unicode_ci\r\n4. Check if everything is working fine.\r\n\r\n#### Observations\r\n\r\nI'm not sure if anything else is needed. @richard67 since you're like the utf8mb4 \"guru\", can you confirm this is what is needed for com_localise to support utf8mb4 too?"},"comment":{"url":"https://api.github.com/repos/joomla-projects/com_localise/issues/comments/197849860","html_url":"https://github.com/joomla-projects/com_localise/pull/286#issuecomment-197849860","issue_url":"https://api.github.com/repos/joomla-projects/com_localise/issues/286","id":197849860,"user":{"login":"andrepereiradasilva","id":9630530,"avatar_url":"https://avatars.githubusercontent.com/u/9630530?v=3","gravatar_id":"","url":"https://api.github.com/users/andrepereiradasilva","html_url":"https://github.com/andrepereiradasilva","followers_url":"https://api.github.com/users/andrepereiradasilva/followers","following_url":"https://api.github.com/users/andrepereiradasilva/following{/other_user}","gists_url":"https://api.github.com/users/andrepereiradasilva/gists{/gist_id}","starred_url":"https://api.github.com/users/andrepereiradasilva/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andrepereiradasilva/subscriptions","organizations_url":"https://api.github.com/users/andrepereiradasilva/orgs","repos_url":"https://api.github.com/users/andrepereiradasilva/repos","events_url":"https://api.github.com/users/andrepereiradasilva/events{/privacy}","received_events_url":"https://api.github.com/users/andrepereiradasilva/received_events","type":"User","site_admin":false},"created_at":"2016-03-17T12:07:15Z","updated_at":"2016-03-17T12:07:15Z","body":"thanks, will try also do tests on a 5.1.x server to see exactly what will happen."}}