main logo
Subject: Re: [SQL] Search ignoring extended characters
Author: jda
Posted: 2002/06/29 15:57:11
 
View Entire Thread
New Search


>Hi Ruslan,
>
>>ok, I see now whats the reason: My fiel has language "German", and
>>there it works. French will work, too. When you choose "English"
>>(which is same as ASCII, I think), it does not work.
>
>This leads me to the question if there is a language setting for
>English where high ascii characters are handled more like in German
>or French. That means, extended characters are is not sorted by
>their ascii value (which is quite nonsense) but normalized to their
>base character?
>

Paul, I believe they *are* sorted without regard to accent with the
language set to English. It's the SQL query that distinguishes
between them. So that leads me to the same question: Ruslan, why
can't we choose to have extended ASCII characters treated like their
base values when doing a search (as in German)? I guess I could
arbitrarily set the field language to German (or French) but I don't
know if that would have any unexpected side effects.

Jon
 
©2002 jda
<-- Prior Message New Search Next Message -->