title: Unexpected character. (near "\"
body: <p>so I'm updating my tables within phpmyadmin. The data is in it, a column was successfully created. When I attempted to add images with the code below, I got this error</p>
  
  <blockquote>
    <p>Unexpected character. (near "\" at position 78)
    Unexpected character. (near "\" at position 84)
    Unexpected character. (near "\" at position 91)
    Unexpected character. (near "\" at position 98)
    Ending quote ' was expected. (near "" at position 166)</p>
  </blockquote>
  
  <p>Code:</p>
  
  <pre><code>UPDATE leleshwa SET BlobColumn = (SELECT  BulkColumn FROM OPENROWSET(BULK 'C:\xampp\htdocs\images\Vitabiotics Wellwoman Drink.jpg', SINGLE_BLOB) AS img) WHERE ID = 1
  </code></pre>
  
  <p><strong>UPDATE</strong></p>
  
  <p>When I switch the direction of the slash for the path (The N before the path seems to make no difference with or without), </p>
  
  <p><code>UPDATE leleshwa SET BlobColumn = (SELECT  BulkColumn FROM OPENROWSET(BULK 'C:/xampp/htdocs/images/Vitabiotics Wellwoman Drink.jpg', SINGLE_BLOB) AS img) WHERE</code>ID<code>= 1</code></p>
  
  <p>the above errors disappear, but I get the following confusing error </p>
  
  <blockquote>
    <p>Ending quote ' was expected. (near "" at position 174)</p>
  </blockquote>
  
  <p>What confuses me more is that the error points to the code by <strong>img</strong>, but position 174 is at the end of the query.</p>