MYSQL & Hebrew sorting problem

[MtK]

Hi,

I have a MYSQL Server, which has a DB with some Hebrew tables...

when trying to sort them by an Hebrew alpha-betic field, the order is incorrect.

the same action by an English alph-betic field, work fine...

any ideas?

[MtK]

well, I found the solution by using a BINARY sort of the wanted field...