title: MarkLogic SQL Collation not used
body: <p>I am getting different results using XQuery and SQL using a <strong>case insensitive collation</strong>.</p>
  
  <p>I've got two app servers, a http and a odbc server, configured. Both using the same  collation <a href="http://marklogic.com/collation/en/S1" rel="nofollow noreferrer">http://marklogic.com/collation/en/S1</a>, which should be caseinsensitive.</p>
  
  <p>Following XQueries return the <strong>correct</strong> value:</p>
  
  <pre><code>xquery version "1.0-ml";
  /table[column="Content"];
  xquery version "1.0-ml";
  /table[column="content"]
  </code></pre>
  
  <p>=> Both return the searched document.</p>
  
  <p>Following SQL Query does <strong>not</strong> return the correct value:</p>
  
  <pre><code>select * from table
  where column = 'Content';
  </code></pre>
  
  <p>But this does:</p>
  
  <pre><code>select * from table
  where column = 'content';
  </code></pre>
  
  <p>Is there anything else i need to configure in order to use a caseinsensitive collation with SQL? (except having a odbc server with that collation)</p>