[thelist] sql: order by and umlauts/entities

[Steve Cook]

A little late coming into this - sorry!

I've looked into a similar problem on SQL Server 7. On that database, it
appears to be that one can control which language one is ordering by, but
only during installation of the database! It appeared to be impossible to
alter the value after installation (though there's probably some crafty way
that I haven't come across).

Being in Sweden, we came up against this problem as well and the reinstall
seemed to do the trick - not the most handy of solution though and probably
not at all appicable if you're using MySQL or something.

.steve


----------------------------
Steve Cook
web strategist
Evitbe AB tidigare Biljettpoolen
031-15 16 17   0703-13 26 31
steve.cook at evitbe.com     www.evitbe.com
---------------------------- 

> -----Original Message-----
> From: Joxn [mailto:joxn at vernum.com]
> Sent: den 24 april 2001 22:26
> 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
> -- 
>    || //\\ \\// |\\||  ::  joxn at vernum.com  ::
>  \\|| \\// //\\ ||\\|  ::      8053703      ::
> 
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt ! 
>