<html>
    <head>
      <base href="https://bugs.documentfoundation.org/">
    </head>
    <body><table border="1" cellspacing="0" cellpadding="8">
        <tr>
          <th>Bug ID</th>
          <td><a class="bz_bug_link 
          bz_status_UNCONFIRMED "
   title="UNCONFIRMED - Firebird: Support for collation in the UI"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=116935">116935</a>
          </td>
        </tr>

        <tr>
          <th>Summary</th>
          <td>Firebird: Support for collation in the UI
          </td>
        </tr>

        <tr>
          <th>Product</th>
          <td>LibreOffice
          </td>
        </tr>

        <tr>
          <th>Version</th>
          <td>6.0.3.2 release
          </td>
        </tr>

        <tr>
          <th>Hardware</th>
          <td>All
          </td>
        </tr>

        <tr>
          <th>OS</th>
          <td>All
          </td>
        </tr>

        <tr>
          <th>Status</th>
          <td>UNCONFIRMED
          </td>
        </tr>

        <tr>
          <th>Severity</th>
          <td>normal
          </td>
        </tr>

        <tr>
          <th>Priority</th>
          <td>medium
          </td>
        </tr>

        <tr>
          <th>Component</th>
          <td>Base
          </td>
        </tr>

        <tr>
          <th>Assignee</th>
          <td>libreoffice-bugs@lists.freedesktop.org
          </td>
        </tr>

        <tr>
          <th>Reporter</th>
          <td>gerhard.schaber@gmx.at
          </td>
        </tr></table>
      <p>
        <div>
        <pre>It would be great to have support for UNICODE_CI and/or UNICODE_CI_AI collation
for CHAR and VARCHAR fields in the UI. The character set UTF8 must be set
automatically for those fields. For for new databases the global default
character set is UTF8, now, anyway, if I am not mistaken. The collation could
be provided as list to select from, or generally offered as VARCHAR_IGNORECASE
field type, if that makes sense. I do not know the exact differences between a
VARCHAR_IGNORECASE field in HSQLDB and a VARCHAR field with UNICODE_CI_AI or
UNICODE_CI collation in Firebird.</pre>
        </div>
      </p>


      <hr>
      <span>You are receiving this mail because:</span>

      <ul>
          <li>You are the assignee for the bug.</li>
      </ul>
    </body>
</html>