{"action":"opened","issue":{"url":"https://api.github.com/repos/casatwy/CTPersistance/issues/33","repository_url":"https://api.github.com/repos/casatwy/CTPersistance","labels_url":"https://api.github.com/repos/casatwy/CTPersistance/issues/33/labels{/name}","comments_url":"https://api.github.com/repos/casatwy/CTPersistance/issues/33/comments","events_url":"https://api.github.com/repos/casatwy/CTPersistance/issues/33/events","html_url":"https://github.com/casatwy/CTPersistance/issues/33","id":164513623,"number":33,"title":"Escape character of single quote doesn't work","user":{"login":"DamianSheldon","id":7088985,"avatar_url":"https://avatars.githubusercontent.com/u/7088985?v=3","gravatar_id":"","url":"https://api.github.com/users/DamianSheldon","html_url":"https://github.com/DamianSheldon","followers_url":"https://api.github.com/users/DamianSheldon/followers","following_url":"https://api.github.com/users/DamianSheldon/following{/other_user}","gists_url":"https://api.github.com/users/DamianSheldon/gists{/gist_id}","starred_url":"https://api.github.com/users/DamianSheldon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DamianSheldon/subscriptions","organizations_url":"https://api.github.com/users/DamianSheldon/orgs","repos_url":"https://api.github.com/users/DamianSheldon/repos","events_url":"https://api.github.com/users/DamianSheldon/events{/privacy}","received_events_url":"https://api.github.com/users/DamianSheldon/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-07-08T11:41:27Z","updated_at":"2016-07-08T11:41:27Z","closed_at":null,"body":"======================\r\nQuery Error: \r\n Origin Query is : INSERT INTO `BBCMessageDetailTable` (`id`,`isReaded`,`sendTime`,`fromId`,`toId`,`owner`,`msgType`,`orderId`,`orderType`,`peer`,`status`,`content`) VALUES (NULL,'0','1467975653','16122','22','16122','0','157','2','22','2','I\\'m ');\r\n Error Message is: near \"m\": syntax error\r\n======================\r\n\r\nsqlite> INSERT INTO `BBCMessageDetailTable` (`id`,`isReaded`,`sendTime`,`fromId`,`toId`,`owner`,`msgType`,`orderId`,`orderType`,`peer`,`status`,`content`) VALUES (NULL,'0','1467975653','16122','22','16122','0','157','2','22','2','I\\'m ');\r\n   ...> );\r\n   ...> ');\r\nError: near \"m\": syntax error\r\n\r\nsqlite> INSERT INTO `BBCMessageDetailTable` (`id`,`isReaded`,`sendTime`,`fromId`,`toId`,`owner`,`msgType`,`orderId`,`orderType`,`peer`,`status`,`content`) VALUES (NULL,'0','1467975653','16122','22','16122','0','157','2','22','2','I''m ');\r\nsqlite> select * from BBCMessageDetailTable;\r\n0|0|1467972148|22|Q really |16122|0|156|2|22|1|16122\r\n1|0|1467972118|22|The best |16122|0|156|2|22|2|16122\r\n2|0|1467975594|22|Even |16122|0|157|2|22|1|16122\r\n3|0|1467975622|22|Do not |16122|0|157|2|22|1|16122\r\n4|0|1467975653|22|Im |16122|0|157|2|22|2|16122\r\n5|0|1467975653|22|I'm |16122|0|157|2|22|2|16122\r\n"}}
{"actor":{"display_login":"DamianSheldon"}}