Devart Forums

I have MyDAc 5.55.0.37 for BCB 5.
When I use query "select name from mytable order by name" then the data is sorted correctly in grid, but when I click one the grid columns to chage the order of sorting then letters like Š and Ž will be sorted first: "ŠŽABCD...". It should be "ABC...RSŠŽTU".

Can it be fixed by some configuration?

Please, specify the character set you are using.

utf8_estonian_ci

I could not reproduce the problem.
Please send me a complete small sample at dmitryg*devart*com to demonstrate it, including a script to create and fill table. Also send me the configuration of your MySQL server. You can find it in the Info sheet of TMyConnection Editor.