<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - Base - incorrect ASC order in Form with varchar data"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124054#c6">Comment # 6</a>
on <a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - Base - incorrect ASC order in Form 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:woodford@pobox.com" title="Tim <woodford@pobox.com>"> <span class="fn">Tim</span></a>
</span></b>
<pre>(In reply to Tim from <a href="show_bug.cgi?id=124054#c4">comment #4</a>)
<span class="quote">> (In reply to Alex Thurgood from <a href="show_bug.cgi?id=124054#c2">comment #2</a>)
> > In a directly created embedded firebird ODB file, I see the following in a
> > simple form created via the wizard :
> >
> > AAA
> > AAa
> > Aaa
> > BBB
> > BBb
> > CCC
> > CCc
> >
> >
> > That seems correct to me. Reading the documentation, it appears that the
> > default sort behaviour for varchar in Firebird is dependent on the collation
> > parameter set when the table is created.
>
> Surely I didn't explain well. This would be the order:
>
> ACUÑA GARRIDO
> ALVAREZ DOMÍNGUEZ
> AREA GIL
> Acosta Martínez
> Alonso Fernández
> ÁLVAREZ Gómez
> Águeda Rodríguez</span >
I changed all to lower case except first letter, and except other cases, and I
get this out of order, because of accents and lower case:
Alonso Salgado
Alonso Álvarez -> This one should go first
Zincke Pan
de Colombia -> This one should go before "Zincke..."
Álvarez Rodríguez -> This one should go after "Alonso..."</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>