{"action":"created","issue":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11824","labels_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11824/labels{/name}","comments_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11824/comments","events_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11824/events","html_url":"https://github.com/phpmyadmin/phpmyadmin/issues/11824","id":125287607,"number":11824,"title":"alter table incorrect Character Set syntax","user":{"login":"maxmak","id":16584077,"avatar_url":"https://avatars.githubusercontent.com/u/16584077?v=3","gravatar_id":"","url":"https://api.github.com/users/maxmak","html_url":"https://github.com/maxmak","followers_url":"https://api.github.com/users/maxmak/followers","following_url":"https://api.github.com/users/maxmak/following{/other_user}","gists_url":"https://api.github.com/users/maxmak/gists{/gist_id}","starred_url":"https://api.github.com/users/maxmak/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maxmak/subscriptions","organizations_url":"https://api.github.com/users/maxmak/orgs","repos_url":"https://api.github.com/users/maxmak/repos","events_url":"https://api.github.com/users/maxmak/events{/privacy}","received_events_url":"https://api.github.com/users/maxmak/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/labels/duplicate","name":"duplicate","color":"cccccc"}],"state":"closed","locked":false,"assignee":{"login":"devenbansod","id":5762808,"avatar_url":"https://avatars.githubusercontent.com/u/5762808?v=3","gravatar_id":"","url":"https://api.github.com/users/devenbansod","html_url":"https://github.com/devenbansod","followers_url":"https://api.github.com/users/devenbansod/followers","following_url":"https://api.github.com/users/devenbansod/following{/other_user}","gists_url":"https://api.github.com/users/devenbansod/gists{/gist_id}","starred_url":"https://api.github.com/users/devenbansod/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/devenbansod/subscriptions","organizations_url":"https://api.github.com/users/devenbansod/orgs","repos_url":"https://api.github.com/users/devenbansod/repos","events_url":"https://api.github.com/users/devenbansod/events{/privacy}","received_events_url":"https://api.github.com/users/devenbansod/received_events","type":"User","site_admin":false},"milestone":null,"comments":2,"created_at":"2016-01-06T23:32:34Z","updated_at":"2016-01-08T15:19:44Z","closed_at":"2016-01-07T05:31:14Z","body":"When altering a table from phpMyAdmin to change the charset of a field it generates a query like:\r\nALTER TABLE `sitepages` CHANGE `FeaturesID` `FeaturesID` VARCHAR(55) CHARSET=utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;\r\n\r\nMySQL gives an error about the =utf8 part.. I looked up the MySQL docs and the proper syntax would be:\r\n... CHARACTER SET utf8 COLLATE utf8_general_ci .... \r\nsource: http://dev.mysql.com/doc/refman/5.6/en/charset-table.html\r\n\r\nIssue on phpMyAdmin Version 4.5.3.1 (I use MySQL 5.6)\r\n"},"comment":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/comments/170029455","html_url":"https://github.com/phpmyadmin/phpmyadmin/issues/11824#issuecomment-170029455","issue_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11824","id":170029455,"user":{"login":"devenbansod","id":5762808,"avatar_url":"https://avatars.githubusercontent.com/u/5762808?v=3","gravatar_id":"","url":"https://api.github.com/users/devenbansod","html_url":"https://github.com/devenbansod","followers_url":"https://api.github.com/users/devenbansod/followers","following_url":"https://api.github.com/users/devenbansod/following{/other_user}","gists_url":"https://api.github.com/users/devenbansod/gists{/gist_id}","starred_url":"https://api.github.com/users/devenbansod/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/devenbansod/subscriptions","organizations_url":"https://api.github.com/users/devenbansod/orgs","repos_url":"https://api.github.com/users/devenbansod/repos","events_url":"https://api.github.com/users/devenbansod/events{/privacy}","received_events_url":"https://api.github.com/users/devenbansod/received_events","type":"User","site_admin":false},"created_at":"2016-01-08T15:19:44Z","updated_at":"2016-01-08T15:19:44Z","body":"Sorry, the above link is incorrect.\r\n\r\nThe correct patch link is: https://github.com/devenbansod/phpmyadmin/commit/28a5a2693bb6bd079c1feddd3d0c4b5753156d44.patch in PR #11779."}}