title: Firebird order by collation
body: <p>I am with strange problem with <strong>Firebird 2.5</strong>.</p>
  
  <p>My database has default charset = utf8.</p>
  
  <p>I have a column <strong>p_nname</strong> in <strong>patienten</strong> table:</p>
  
  <pre><code>CREATE TABLE PATIENTEN (
     P_NNAME       VARCHAR(25) DEFAULT '' NOT NULL COLLATE UNICODE_CI,
  </code></pre>
  
  <p>I expect collation to work everywhere. I mean in WHERE and ORDER BY clauses.</p>
  
  <p>What I have is working collation in WHERE. Two queries below give me similar result and it is good.</p>
  
  <pre><code>select * from patienten where p_nname='adler'
  select * from patienten where p_nname='ADler'
  </code></pre>
  
  <p>Problem is ORDER BY clause does not work as I expect.</p>
  
  <p>This SQL works as if the column has no UNICODE_CI collation.</p>
  
  <pre><code>select * from patienten order by p_nname
  </code></pre>
  
  <p>To get the needed result with good sorting I have to write so:</p>
  
  <pre><code>select * from patienten order by p_nname collate unicode_ci
  </code></pre>
  
  <p>Is there a way to omit COLLATE flag in ORDER BY clause?</p>