ORDER BY gives wrong alphabetical order for ISO Greek

ml31 · #1 (**permalink**) 04-29-04, 04:41

I really don't understand. I'm doing a relatively simple query on a table that has entries in ISO Greek (ISO 8859-7) and English that I'd like to be in alphabetical order. Something like: SELECT * FROM abook ORDER BY lastname. But the order is all wrong. Almost at random... What can I do about this? Maybe I have to edit some MySQL configuration file or something...

nouvaki · #2 (**permalink**) 06-03-06, 05:25

I have the same problem...Pls help

dbmab · #3 (**permalink**) 06-03-06, 06:38

Try something like this -

Code:

SELECT * FROM abook ORDER BY lastname COLLATE greek_general_ci

Internet Services

Web Development

Digital Marketing

Consumer Tech