title: Loading JSON data with apostrophe (single quote) i
body: <p>This is specifically regarding insert of data into CrateDB,</p>
  
  <p>I have a table with one column of type OBJECT.  I am trying to insert JSON data into that using python and it is going along fine.</p>
  
  <p>create table users (userdata OBJECT);</p>
  
  <p>However, my data has apostrophe's in it i.e. single quotes and so the insert is failing.  I have replicated the problem on the console:</p>
  
  <p>The problem in the data below is with the "snr" field. I have tried putting in a backslash but that does not help.  </p>
  
  <p>Can someone tell me how I can get the following insert to </p>
  
  <pre><code>INSERT into users (userdata) 
  VALUES ('{"area_code": "2", "companyname": "TEC", "cos": "National24Hrs-Standard", 
  "country_code": "AUS", "cucm_dn": "26902", "ddi": "84236902", "department": null, 
  "device_type": "Cisco 8945 SIP", "divisionname": "Demonstrations", 
  "emailaddress": "bart.simpson@core.demo.telstra.com", "extension": "26902", 
  "extra1": null, "extra2": null, "extra3": null, "extra4": null, 
  "featuregroup": "Mobile Worker", "firstname": "Bart", "information": null, 
  "ippbxchosen": "TEC-CL-1", "language": "English - United States", "lastname": "Simpson", 
  "locationname": "Sydney", "mask": "61284236902", "pickupgroup": null, "postcode": "2000", 
  "presence": "Y", "role": "enduser", "security_profile": "EndUser-SP1", 
  "snr": "Bart\'s Mobile:0457503561,Bart Simpson:457503561", 
  "username": "bart.simpson@core.demo.telstra.com", "voicemail": "UCX-Advanced-CoS"}')
  </code></pre>