[6.6.3s] SortedFields Ignoring Charset/Collation on 'Umlaut'

[expert173]

Hi,

Using Delphi 5 and zeos 6.6.3-stable with doNotSortOnPost Hack/Mod on mySQL 5.0 under WinXP Clint and W2k/W2k3 Server.

2 days ago a customer complained that our program is doing shit on sorting our German Umlaute (ä,ö,ü,Ä,Ö,Ü,ß), and unfortunately he was right.

After long tests i found out that the Problem seems to be in the Sorting of the zeos components.

On Using Charset latin1 and collation latin1_general_ci in phpmyadmin, HeidiSQL and else everything is how it should be:

Select Name From Kunden Order By Name
...
Woo
Wor
Wor
Wö
Wöh
Wös
...

And executing an SQL-Statement with "Order By" on a Fresh TZQuery has even the same result.

But the problem is: Using a simple "Select Fields From Table" and letting zeos Sort the data by SortedFields causes things like:

Select Name From Kunden
TZQuery.SortedFields := 'Name';
...
Wö
Wöh
Woo
Wor
Wor
Wös
...

Which is definitely wrong. But how can i solve this?

mfg expert173

[German]
Die SortedFields der Zeos-Komponenten, bzw. dessen Sortierung würfelt Umlaute entgegen der vorgabe des charset/collation einfach unter die "Normalen"-Versionen der Buchstaben.
Jemand ne Idee was da schief leuft?