> Write a function that strips out the characters you want to
> ignore
> (returning the rest of the given string) and then create an
> index on
> that function.
>
Hmm, thanks for the suggesgion. Although the problem seems to have been that
the locale I was using was ignoring those characters
Hmm, I understand what you're saying, but how ion earth do I create
a function that reorders the result based on all the different
characters ^ . * etc that could cause this?
Write a function that strips out the characters you want to ignore
(returning the rest of the given string) and then
Glyn Astill <[EMAIL PROTECTED]> writes:
> I'd expect the rows starting with the caret to appear either at the start or
> end of, rather than in the middle, it appears as if the index ignores them.
>
> Database locale is Latin1
Latin1 isn't a locale, it's a character set (and an encoding).
Your
>
> > 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
Glyn Astill <[EMAIL PROTECTED]> writes:
> I was just wondering if there's any way to tweak the way an an index is
> ordered on a text field?
> 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 char
>
> > Hi chaps,
> >
> > I was just wondering if there's any way to tweak
> the way an an index is ordered on a text field?
>
> Yes, it's called functional index. Write your function,
> which does
> whatever you want with your data and create index
> (foo(artist))
>
Hmm, I understand what you're
