title: HSQL (Hypersonic SQL) throwing error when using NLSSORT
body: <p>I am getting the following error when running unit tests using HSQL.</p>
  
  <blockquote>
    <p>Cause: java.sql.SQLSyntaxErrorException: user lacks privilege or
    object not found: NLSSORT ; bad SQL grammar []; nested exception is
    java.sql.SQLSyntaxErrorException: user lacks privilege or object not
    found: NLSSORT</p>
  </blockquote>
  
  <p>I have selected to use to oracle dialect in the HSQL configurations which work well for other Oracle specific queries.</p>
  
  <p>Here is the query that is failing;</p>
  
  <pre><code> select COUNTRY_CODE, COUNTRY_E_DESC
  
                  from COUNTRY
  
                  order by nlssort(COUNTRY_E_DESC ,'NLS_SORT=BINARY_AI')
  </code></pre>
  
  <p>Is there another configuration I need to set to get HSQL to use NLSSORT?</p>