Problem sorting fields that contain two or more languages

Angelo · Post by **Angelo** » Fri 30 Nov 2007 09:00

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

Antaeus · Post by **Antaeus** » Fri 30 Nov 2007 11:55

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.

Angelo · Post by **Angelo** » Mon 03 Dec 2007 07:28

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

Antaeus · Post by **Antaeus** » Mon 03 Dec 2007 14:30

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