Sort non-English names with MySQL

Question

I am trying to sort a table containing Greek characters. The corresponding English version of the table is sorted (both ASC, and DESC) just fine, every time you click on the table title.

I searched on the Greek forums and the only suggested solution is to use ORDER BY BINARY. In fact, many people have said that using binary order solves their problem. Unfortunately, this is not in my case. I know that the same problem exists in languages ​​like German, where the use of umlauts violates the order and generally in languages ​​with special characters. If anyone knows how to overcome this problem, I would be grateful.

Answer 1

According to the thread on forums.mysql.com , in MySQL 6.0 you can sort Greek names if the encoding of your table is set to utf8_general_ci.

create table t (s1 char(1) character set utf8 collate utf8_general_ci); 
insert into t values ('Α'),('Β'),('Γ'),('Δ'),('Ε'),('Ζ');
select * from t order by s1;

The above should return

+----+ 
| s1 | 
+----+ 
| Α  | 
| Β  | 
| Γ  | 
| Δ  | 
| Ε  | 
| Ζ  |
+----+