Re: greek collation & sorting

2007-06-27 Thread tasos
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

Re: greek collation & sorting

2007-06-27 Thread Martin Gainty
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--