{"action":"closed","issue":{"url":"https://api.github.com/repos/actiontech/dble/issues/389","repository_url":"https://api.github.com/repos/actiontech/dble","labels_url":"https://api.github.com/repos/actiontech/dble/issues/389/labels{/name}","comments_url":"https://api.github.com/repos/actiontech/dble/issues/389/comments","events_url":"https://api.github.com/repos/actiontech/dble/issues/389/events","html_url":"https://github.com/actiontech/dble/issues/389","id":281309171,"number":389,"title":"ucs2, utf16, and utf32 cannot be used as a client character set","user":{"login":"sevenFH","id":22519004,"avatar_url":"https://avatars2.githubusercontent.com/u/22519004?v=4","gravatar_id":"","url":"https://api.github.com/users/sevenFH","html_url":"https://github.com/sevenFH","followers_url":"https://api.github.com/users/sevenFH/followers","following_url":"https://api.github.com/users/sevenFH/following{/other_user}","gists_url":"https://api.github.com/users/sevenFH/gists{/gist_id}","starred_url":"https://api.github.com/users/sevenFH/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sevenFH/subscriptions","organizations_url":"https://api.github.com/users/sevenFH/orgs","repos_url":"https://api.github.com/users/sevenFH/repos","events_url":"https://api.github.com/users/sevenFH/events{/privacy}","received_events_url":"https://api.github.com/users/sevenFH/received_events","type":"User","site_admin":false},"labels":[{"id":676159239,"url":"https://api.github.com/repos/actiontech/dble/labels/Function","name":"Function","color":"1d76db","default":false},{"id":676160275,"url":"https://api.github.com/repos/actiontech/dble/labels/sql-coverage","name":"sql-coverage","color":"fef2c0","default":false}],"state":"closed","locked":false,"assignee":{"login":"yanhuqing666","id":16715575,"avatar_url":"https://avatars1.githubusercontent.com/u/16715575?v=4","gravatar_id":"","url":"https://api.github.com/users/yanhuqing666","html_url":"https://github.com/yanhuqing666","followers_url":"https://api.github.com/users/yanhuqing666/followers","following_url":"https://api.github.com/users/yanhuqing666/following{/other_user}","gists_url":"https://api.github.com/users/yanhuqing666/gists{/gist_id}","starred_url":"https://api.github.com/users/yanhuqing666/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yanhuqing666/subscriptions","organizations_url":"https://api.github.com/users/yanhuqing666/orgs","repos_url":"https://api.github.com/users/yanhuqing666/repos","events_url":"https://api.github.com/users/yanhuqing666/events{/privacy}","received_events_url":"https://api.github.com/users/yanhuqing666/received_events","type":"User","site_admin":false},"assignees":[{"login":"yanhuqing666","id":16715575,"avatar_url":"https://avatars1.githubusercontent.com/u/16715575?v=4","gravatar_id":"","url":"https://api.github.com/users/yanhuqing666","html_url":"https://github.com/yanhuqing666","followers_url":"https://api.github.com/users/yanhuqing666/followers","following_url":"https://api.github.com/users/yanhuqing666/following{/other_user}","gists_url":"https://api.github.com/users/yanhuqing666/gists{/gist_id}","starred_url":"https://api.github.com/users/yanhuqing666/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yanhuqing666/subscriptions","organizations_url":"https://api.github.com/users/yanhuqing666/orgs","repos_url":"https://api.github.com/users/yanhuqing666/repos","events_url":"https://api.github.com/users/yanhuqing666/events{/privacy}","received_events_url":"https://api.github.com/users/yanhuqing666/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/actiontech/dble/milestones/5","html_url":"https://github.com/actiontech/dble/milestone/5","labels_url":"https://api.github.com/repos/actiontech/dble/milestones/5/labels","id":2907140,"number":5,"title":"2.17.11.0","description":"1.prepare syntax  \r\n  \r\n2.sub query   \r\n\r\n3.view   \r\n\r\n4.refactor Derived Tables  \r\n\r\n5.optimize limit without order by","creator":{"login":"yanhuqing666","id":16715575,"avatar_url":"https://avatars1.githubusercontent.com/u/16715575?v=4","gravatar_id":"","url":"https://api.github.com/users/yanhuqing666","html_url":"https://github.com/yanhuqing666","followers_url":"https://api.github.com/users/yanhuqing666/followers","following_url":"https://api.github.com/users/yanhuqing666/following{/other_user}","gists_url":"https://api.github.com/users/yanhuqing666/gists{/gist_id}","starred_url":"https://api.github.com/users/yanhuqing666/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yanhuqing666/subscriptions","organizations_url":"https://api.github.com/users/yanhuqing666/orgs","repos_url":"https://api.github.com/users/yanhuqing666/repos","events_url":"https://api.github.com/users/yanhuqing666/events{/privacy}","received_events_url":"https://api.github.com/users/yanhuqing666/received_events","type":"User","site_admin":false},"open_issues":12,"closed_issues":41,"state":"open","created_at":"2017-11-13T06:26:27Z","updated_at":"2017-12-25T07:38:45Z","due_on":null,"closed_at":null},"comments":0,"created_at":"2017-12-12T09:15:33Z","updated_at":"2017-12-25T07:38:45Z","closed_at":"2017-12-25T07:38:45Z","author_association":"COLLABORATOR","body":"dble:  \r\n```\r\nmysql> set names 'utf16';\r\nQuery OK, 0 rows affected (0.00 sec)\r\n\r\nmysql> select @@character_set_client,@@character_set_connection,@@character_set_results;\r\nERROR 1064 (þÿ): Y\r\nmysql> select @@character_set_client,@@character_set_connection,@@character_set_results;\r\nERROR 2013 (HY000): Lost connection to MySQL server during query\r\nmysql> select @@character_set_client,@@character_set_connection,@@character_set_results;\r\nERROR 2006 (HY000): MySQL server has gone away\r\nNo connection. Trying to reconnect...\r\nConnection id:    94800\r\nCurrent database: mytest\r\n\r\n+------------------------+----------------------------+-------------------------+\r\n| @@character_set_client | @@character_set_connection | @@character_set_results |\r\n+------------------------+----------------------------+-------------------------+\r\n| utf8                   | utf8                       | utf8                    |\r\n+------------------------+----------------------------+-------------------------+\r\n1 row in set (0.00 sec)\r\n``` \r\n```\r\n\r\nmysql> set @@character_set_client='ucs2';\r\nQuery OK, 0 rows affected (0.01 sec)\r\n\r\nmysql> select @@character_set_client;\r\nERROR 1064 (HY000): syntax error, error in :'獥汥捴⁀䁣桡牡捴敲彳整彣汩敮�',expect IDENTIFIER, actual IDENTIFIER 獥汥捴⁀䁣桡牡捴敲彳整彣汩敮�\r\nmysql> select @@character_set_client;\r\nERROR 1064 (HY000): syntax error, error in :'獥汥捴⁀䁣桡牡捴敲彳整彣汩敮�',expect IDENTIFIER, actual IDENTIFIER 獥汥捴⁀䁣桡牡捴敲彳整彣汩敮�\r\nmysql> select @@character_set_client;\r\nERROR 1064 (HY000): syntax error, error in :'獥汥捴⁀䁣桡牡捴敲彳整彣汩敮�',expect IDENTIFIER, actual IDENTIFIER 獥汥捴⁀䁣桡牡捴敲彳整彣汩敮�\r\nmysql> select @@character_set_client;\r\nERROR 1064 (HY000): syntax error, error in :'獥汥捴⁀䁣桡牡捴敲彳整彣汩敮�',expect IDENTIFIER, actual IDENTIFIER 獥汥捴⁀䁣桡牡捴敲彳整彣汩敮�\r\nmysql> show tables;\r\nERROR 1064 (HY000): syntax error, error in :'獨潷⁴慢汥�',expect IDENTIFIER, actual IDENTIFIER 獨潷⁴慢汥�\r\n```\r\nmysql:  \r\n```\r\nmysql> set @@character_set_client='ucs2';\r\nERROR 1231 (42000): Variable 'character_set_client' can't be set to the value of 'ucs2'\r\nmysql> set names 'ucs2';\r\nERROR 1231 (42000): Variable 'character_set_client' can't be set to the value of 'ucs2'\r\nmysql> \r\n```\r\nDble behavior should be consistent with MySQL.\r\n"}}
{"actor":{"display_login":"sevenFH"}}