[thelist] sql: order by and umlauts/entities

Joxn joxn at vernum.com
Tue Apr 24 15:26:29 CDT 2001

I have a table containing names which have umlauts saved as entities in
it, eg. "Köln".

If I do a "select name order by name" on this table, I get "Köln -
Kassel" instead of "Kassel - Köln".

This is quite logical, but is there a way using SQL to change this?
I don't like the idea of using PHP to sort this array afterwards...

   || //\\ \\// |\\||  ::  joxn at vernum.com  ::
 \\|| \\// //\\ ||\\|  ::      8053703      ::

More information about the thelist mailing list