Hello sir and thanks for replying.
I'm have tried all greek collations.The fact is that when sorting i see first
the latin
characters(sorted) and then the greek ones(again sorted).I want to have a
choice.I mean i want to
see first the A latin and then the greek A.Then B latin and B greek etc.Or
I would wait until your DB is offline (such as on a weekend)
Once you find the Character Set you want e.g. greek_general_ci
http://dev.mysql.com/doc/refman/5.0/en/charset-se-me-sets.html
then alter your DB to use that character set
http://dev.mysql.com/doc/refman/5.0/en/charset-database.html
M--