[thelist] sql: order by and umlauts/entities

[Joxn]

rudy wrote:
> maybe use a regexp? (i'm guessing, because don't know how to write
> those)...
> 
> it would have to search the string for each entity and replace it with the
> unaccented character for sorting purposes, i.e. replace the six characters
> "ö" with the single character "o"
> 
> and you'd have to do that for all the entities you're likely to find in the
> table

This sounds interesting.

Actually, I have only a handful of entities that I need to convert:
ö = ö, Ö = Ö
ä = ä, Ä = Ä
ü = ü, Ü = Ü
ß = ß

How do I apply such a regexp to my select and order by?
Does anyone have an example?

Thanks in advance.

bye Joxn
-- 
   || //\\ \\// |\\||  ::  joxn at vernum.com  ::
 \\|| \\// //\\ ||\\|  ::      8053703      ::