[thelist] sql: order by and umlauts/entities

Bruce Heerssen bheerssen at visualbridge.tv
Tue Apr 24 15:42:34 CDT 2001


Sure, use the ASC or DESC (ascending or descending) modifiers, eg: "order by name ASC"

- Bruce


> -----Original Message-----
> From: thelist-admin at lists.evolt.org
> [mailto:thelist-admin at lists.evolt.org]On Behalf Of Joxn
> Sent: Tuesday, April 24, 2001 3:26 PM
> To: thelist at lists.evolt.org
> Subject: [thelist] sql: order by and umlauts/entities
>
>
> 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





More information about the thelist mailing list