Devart Forums

I am currently using MYSQL server version 5 and myDAC version 4.40.0.21 for delphi 6 and i have this problem....

My Database table uses UTF8 with Binary collation

In a table I have a field that contains both greek and english data..
When i use the MYQuery property "IndexFieldNames" the table is not sorted out correctly (The order displayed is completely random, in other words the sorting mixes greek and english together as well as fields starting with numbers) but by using "order by" in the sql statment its correct. Any suggestions on why the IndexFieldNames property is not sorting correctly...

Could you prepare a complete small project that demonstrates this problem (including the database with a test table(s))? You can send it to mydac*crlab*com.
The test project would help us very much.

I have sent you a small program that highlights the problem together with the script to create the table and saom sample data.
I Zipped the program and sent it to mydac*crlab*com without the executable file just incase the email gets blocked so you will have to compile aswell

Thankyou for your prompt reply!!

Angelo

Thank you again for your sample. I have answered your e-mail.