title: mysql - storing json, double quote escape issue
body: <p>I've been chasing a JSON bug about and discovered that I'm getting different results if I load a file from disk as to loading the (apparently) same file from the db.</p>
  
  <p>Mysql seems to be stealing my escape characters. (I'm using vbscript; my connect string is <code>Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=foo;User=foo;Password=f00;Option=3;</code>)</p>
  
  <p>On doing a conn.execute(...) </p>
  
  <pre><code>update courses set config = '{"set": "value in \"here\" ok?"}' where id = 21;
  select config from courses where id = 21;
  // prints changed value {"set": "value in "here" ok?"}
  </code></pre>
  
  <p>What's going on here? Why is mysql taking out my <code>\"</code> and turning them into <code>"</code>?</p>
  
  <p>If I use workbench on the server (windows 2003) and use the feature "load value from file" in the results pane, I can import the json to the field and it retains the proper escape sequence values. But doing an update / insert, the escape sequence characters are <strong><em>lost</em></strong>.</p>