{"action":"created","issue":{"url":"https://api.github.com/repos/vert-x3/vertx-jdbc-client/issues/67","repository_url":"https://api.github.com/repos/vert-x3/vertx-jdbc-client","labels_url":"https://api.github.com/repos/vert-x3/vertx-jdbc-client/issues/67/labels{/name}","comments_url":"https://api.github.com/repos/vert-x3/vertx-jdbc-client/issues/67/comments","events_url":"https://api.github.com/repos/vert-x3/vertx-jdbc-client/issues/67/events","html_url":"https://github.com/vert-x3/vertx-jdbc-client/issues/67","id":163080057,"number":67,"title":"[vert.x jdbc-client: 3.3.0] java.sql.SQLException: Incorrect string value: '\\xAC\\xED\\x00\\x05sr…'","user":{"login":"huynhduy9988","id":5541345,"avatar_url":"https://avatars.githubusercontent.com/u/5541345?v=3","gravatar_id":"","url":"https://api.github.com/users/huynhduy9988","html_url":"https://github.com/huynhduy9988","followers_url":"https://api.github.com/users/huynhduy9988/followers","following_url":"https://api.github.com/users/huynhduy9988/following{/other_user}","gists_url":"https://api.github.com/users/huynhduy9988/gists{/gist_id}","starred_url":"https://api.github.com/users/huynhduy9988/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/huynhduy9988/subscriptions","organizations_url":"https://api.github.com/users/huynhduy9988/orgs","repos_url":"https://api.github.com/users/huynhduy9988/repos","events_url":"https://api.github.com/users/huynhduy9988/events{/privacy}","received_events_url":"https://api.github.com/users/huynhduy9988/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2016-06-30T04:46:40Z","updated_at":"2016-06-30T10:11:49Z","closed_at":null,"body":"### Version\r\n\r\n* vert.x core: 3.3.0\r\n* vert.x jdbc-client: 3.3.0\r\n* jdbc driver: 6.0.2, 6.0.3, 5.1.39\r\n* RDBMS: MySQL, character set utf8mb4, collation utf8mb4_general_ci\r\n\r\n### Problem\r\n- I insert new record in MySQL table with character set utf8mb4, collation utf8mb4_general_ci then get error \"java.sql.SQLException: Incorrect string value: '\\xAC\\xED\\x00\\x05sr…'\"\r\n- Stackoverflow reference: http://stackoverflow.com/questions/15063635/java-sql-sqlexception-incorrect-string-value-xac-xed-x00-x05sr?lq=1\r\n- I had never get this error in previous vertx version (3.2.1)\r\n- I revert vertx 3.2.1 and everything work\r\n- Please help me fix"},"comment":{"url":"https://api.github.com/repos/vert-x3/vertx-jdbc-client/issues/comments/229618211","html_url":"https://github.com/vert-x3/vertx-jdbc-client/issues/67#issuecomment-229618211","issue_url":"https://api.github.com/repos/vert-x3/vertx-jdbc-client/issues/67","id":229618211,"user":{"login":"huynhduy9988","id":5541345,"avatar_url":"https://avatars.githubusercontent.com/u/5541345?v=3","gravatar_id":"","url":"https://api.github.com/users/huynhduy9988","html_url":"https://github.com/huynhduy9988","followers_url":"https://api.github.com/users/huynhduy9988/followers","following_url":"https://api.github.com/users/huynhduy9988/following{/other_user}","gists_url":"https://api.github.com/users/huynhduy9988/gists{/gist_id}","starred_url":"https://api.github.com/users/huynhduy9988/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/huynhduy9988/subscriptions","organizations_url":"https://api.github.com/users/huynhduy9988/orgs","repos_url":"https://api.github.com/users/huynhduy9988/repos","events_url":"https://api.github.com/users/huynhduy9988/events{/privacy}","received_events_url":"https://api.github.com/users/huynhduy9988/received_events","type":"User","site_admin":false},"created_at":"2016-06-30T10:11:49Z","updated_at":"2016-06-30T10:11:49Z","body":"@pmlopes: \r\n-- Table \r\nCREATE TABLE `test` (\r\n  `autoId` bigint(20) NOT NULL AUTO_INCREMENT,\r\n  `ID` varchar(36) NOT NULL,\r\n  `user` varchar(20) NOT NULL DEFAULT ''\r\n\tPRIMARY KEY (`autoId`),\r\n    UNIQUE KEY `id_UNIQUE` (`ID`),\r\n\tKEY `MUSER` (`user`)\r\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;\r\n\r\n-- Store procedure\r\nCREATE DEFINER=`root`@`%` PROCEDURE `sp_test_INSERT`(\r\n    p_ID                \tvarchar(36)     ,\r\n\tp_user              \tvarchar(20)\r\n)\r\nBEGIN\r\n INSERT INTO test\r\n         (\r\n   \t\t\tID                ,\r\n\t\t\tuser              \r\n         )\r\n    VALUES \r\n         ( \r\n\t\t\tp_ID                ,\r\n\t\t\tp_user              \t\t\t\r\n         ); \r\nEND\r\n-- Java code\r\nJsonArray inParam = new JsonArray()\r\n        .add(\"31cdd954-b091-4c4c-97a1-6da723d11600\")\r\n        .add(\"user\");                \r\n\r\ndoCallWithParams(\"{ call sp_test_INSERT(?, ?) }\", inParam, null, new Handler<AsyncResult<ResultSet>>() {\r\n    @Override\r\n    public void handle(AsyncResult<ResultSet> asyncResult) {\r\n      \r\n    }\r\n});\r\n\r\n-- Database info\r\nSHOW VARIABLES WHERE Variable_name LIKE 'character\\_set\\_%' OR Variable_name LIKE 'collation%';\r\n+--------------------------+--------------------+\r\n| Variable_name            | Value              |\r\n+--------------------------+--------------------+\r\n| character_set_client     | utf8               |\r\n| character_set_connection | utf8               |\r\n| character_set_database   | utf8mb4            |\r\n| character_set_filesystem | binary             |\r\n| character_set_results    | utf8               |\r\n| character_set_server     | utf8mb4            |\r\n| character_set_system     | utf8               |\r\n| collation_connection     | utf8_general_ci    |\r\n| collation_database       | utf8mb4_general_ci |\r\n| collation_server         | utf8mb4_general_ci |\r\n+--------------------------+--------------------+\r\n-- JDBC connection\r\n      \"url\":\"jdbc:mysql://localhost:3306/test_db?autoReconnect=true&useUnicode=true&useSSL=false&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC\",\r\n      \"driver_class\":\"com.mysql.jdbc.Driver\",\r\n      \"user\":\"root\",\r\n      \"password\":\"root\",\r\n      \"initial_pool_size\":3,\r\n      \"min_pool_size\":3,\r\n      \"max_pool_size\":50,\r\n      \"max_statements\":500,\r\n      \"max_statements_per_connection\":0,\r\n      \"max_idle_time\":5,\r\n      \"database\":\"test_db\""}}
{"actor":{"display_login":"huynhduy9988"}}