<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:robert@familiegrosskopf.de" title="Robert Großkopf <robert@familiegrosskopf.de>"> <span class="fn">Robert Großkopf</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - FIREBIRD: incorrect ASC order with varchar data"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124054">bug 124054</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEW
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr>
<tr>
<td style="text-align:right;">Summary</td>
<td>Base - incorrect ASC order in Form with varchar data containing accented characters
</td>
<td>FIREBIRD: incorrect ASC order with varchar data
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - FIREBIRD: incorrect ASC order with varchar data"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124054#c25">Comment # 25</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - FIREBIRD: incorrect ASC order with varchar data"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124054">bug 124054</a>
from <span class="vcard"><a class="email" href="mailto:robert@familiegrosskopf.de" title="Robert Großkopf <robert@familiegrosskopf.de>"> <span class="fn">Robert Großkopf</span></a>
</span></b>
<pre>The order of characters is Firebird-specific. I have changed the title for
this.
Note: Has nothing to do with migration, it is the default behaviour of a new
created database in LO 6.3.0.0.beta1:
Create a new database
Create a table with ID - INTEGER (primrary key), "Name" - VARCHAR
Input some data:
1 Aaa
2 Ba
3 Za
4 ab
5 ca
This data will be sorted by a query:
SELECT "Name" ORDER BY "Name" ASC
It will be shown the same way as sorted above: Capital letters first.
SELECT "Name" ORDER BY "Name" COLLATE UNICODE ASC
It will only work in direct SQL, so unusable for input data. But it will order
"Name" as the order will be in HSQLDB:
Aaa
ab
Ba
ca
Za
I could confirm this buggy behaviour with LO 6.3.0.0.beta1 on OpenSUSE 15,
64bit rpm Linux with a new created Firebird database.</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>