[thelist] sql: order by and umlauts/entities
Joxn
joxn at vernum.com
Tue Apr 24 15:26:29 CDT 2001
Hi,
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...
TIA,
Joxn
--
|| //\\ \\// |\\|| :: joxn at vernum.com ::
\\|| \\// //\\ ||\\| :: 8053703 ::
More information about the thelist
mailing list