[thelist] sql: order by and umlauts/entities
Joxn
joxn at vernum.com
Wed Apr 25 02:59:51 CDT 2001
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 ::
More information about the thelist
mailing list