AW: CollationAttribute messed up handling german umlaute

[Bart Pietercil]

Beat you to it :-)

Bart
On 07 Oct 2008, at 12:07, Tiemo Hollmann TB wrote:

> Sorry for my first post - sometimes reading helps :) just when  
> posting the
> word"accents" I remembered the docs...
> I should have set “kStrength” not to “kPrimary”, but "kSecondary".
> Thanks anyway
> Tiemo
>
>> -----Ursprüngliche Nachricht-----
>> Von: valentina-bounces at lists.macserve.net [mailto:valentina-
>> bounces at lists.macserve.net] Im Auftrag von Tiemo Hollmann TB
>> Gesendet: Dienstag, 7. Oktober 2008 11:59
>> An: ValentinaListe
>> Betreff: CollationAttribute messed up handling german umlaute
>>
>> Hello,
>>
>> I am new to valentina (working with revolution) and this is my first
>> posting
>> to this list, so I want to say hello to all.
>>
>> My issue is that I want always Case insensitivness with all SELECT
>> statements. So I have set the CollationAttribute of the db  
>> “kStrength” to
>> “kPrimary”. So far so good, selecting upper and lower standard  
>> characters
>> works fine.
>>
>> BUT selecting the german umlaute is completely messed up. When  
>> searching
>> for
>> “ä” the select result brings not only all “ä” and “Ä”, but also all  
>> “a”
>> and
>> “A”, same with selecting for “a” brings up “a”, “A”, “ä”, “Ä”. So the
>> german
>> umlaute are handled as their equivalent chars without accents.
>>
>> I am sure (or at least hoping) that some European user has found a
>> solution
>> for this before, because I am really not an SQL pro.
>>
>> Thanks for any suggestion
>>
>> Tiemo
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina