TCRDBGrid and sorting international characters

rihoe · Post by **rihoe** » Sat 25 Oct 2008 18:13

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?

Dimon · Post by **Dimon** » Mon 27 Oct 2008 11:16

Please, specify the character set you are using.

rihoe · Post by **rihoe** » Mon 27 Oct 2008 11:25

utf8_estonian_ci

Dimon · Post by **Dimon** » Tue 28 Oct 2008 09:01

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.