[Libreoffice-bugs] [Bug 124054] Base - incorrect ASC order in Form with varchar data

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=124054

--- Comment #6 from Tim <woodford at pobox.com> ---
(In reply to Tim from comment #4)
> (In reply to Alex Thurgood from comment #2)
> > 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

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..."

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190314/781cb8fb/attachment.html>