> > > I have a table with a varchar field "artist" > (see table def below), > and if I order by the field "artist" it does not > order as expected when > there are characters such as ^ at the start of the text. > > You didn't say what you consider "expected", > but I suspect that the > answer is you want to use a different locale setting ... > probably C. > Unfortunately there's currently no way to change that > short of initdb. > Sorry. I expected the index to order A-Z with anything starting with the carret (or other characters) being either at the end or at the start, not in the middle. I know it's naive, but for some reason I expected the index would order any text in alphabetical order e.g. AA,AB,AC,ZA,ZZ,^A,^Z ...etc I guess if the only soloution is initdb and a different locale, I'll have to find a workaround elsewhere. The client applications that rely on this are a pile of junk anyway.
