title: Query QuickBook Online with UTF-8 characters
body: <p>I'm trying to use the API to query for customers by name. The names with non-ASCII characters (e.g. <code>민준</code> or <code>Włodarski</code>) cause the queries fail. Here's an example query:</p>
  <pre><code>SELECT * FROM Customer WHERE FamilyName = 'Włodarski'
  </code></pre>
  <p>I URL encode it as suggested by <a href="https://developer.intuit.com/hub/blog/2014/03/20/advanced-sql-queries" rel="nofollow noreferrer">https://developer.intuit.com/hub/blog/2014/03/20/advanced-sql-queries</a> and get:</p>
  <pre><code>https://sandbox-quickbooks.api.intuit.com/v3/company/193514472385819/query?query=SELECT%20*%20FROM%20Customer%20WHERE%20LastName%20=%20'W%C5%82odarski'%20STARTPOSITION%201%20MAXRESULTS%201000
  </code></pre>
  <p>But when I submit that request I get back:</p>
  <pre><code>&lt;IntuitResponse xmlns=&quot;http://schema.intuit.com/finance/v3&quot; time=&quot;2017-03-03T15:14:26.774-08:00&quot;&gt;
    &lt;Fault type=&quot;ValidationFault&quot;&gt;
      &lt;Error code=&quot;4000&quot;&gt;
        &lt;Message&gt;Error parsing query&lt;/Message&gt;
        &lt;Detail&gt;QueryParserError: Invalid content. Lexical error at line 1, column 43.  Encountered: &quot;\u0142&quot; (322), after : &quot;\'W&quot;&lt;/Detail&gt;
      &lt;/Error&gt;
    &lt;/Fault&gt;
  &lt;/IntuitResponse&gt;
  </code></pre>
  <p>What do I need to do to be able to find this customer?</p>
  <p>I'd put the question to Intuit's support and the provided the following:</p>
  <blockquote>
  <p>If you want to query the whole string, you can URL encode the whole query without the non-ASCII character and and then add the URL encoded character to this query. An example of this is:
  <code>select%20%2A%20from%20Customer%20where%20GivenName%3D%27m%C3%A5na</code></p>
  <p><code>select * from Customer where GivenName='måna'</code></p>
  <p><code>%C3%A5</code> is URL encoding of my non-ascii character <code>å</code>.</p>
  <p>You can also do something like this:
  <code>select * from Customer where GivenName like 'm%na'</code> and then encode the whole query which will ignore the second character and search for the rest of the characters in that order.</p>
  </blockquote>
  <p>I think the example they provided with <code>å</code> was chosen because it's part of the extended ASCII character set. I've asked them to clarify if UTF-8 characters can be used as search strings.</p>