On 2/8/19 9:11 AM, David Raymond wrote: > Remember that fancy collations don't just look at 1 character at a time, they > look at the whole thing, and can do surprising stuff based on that. In this > case the order of preference for the collation looks like "when it's part of > a larger word, then treating 'S' and 'Š' the same is more important than > separating them. But when it's just 1 character then they're different. > > So 'S' might be before 'Š', but in words it might go > > 'Sam' > 'Šam' > 'Skunk' > 'Škunk' > 'Sudden' > 'Šudden' > > rather than a simple character-at-a-time order of > > 'Sam' > 'Skunk' > 'Sudden' > 'Šam' > 'Škunk' > 'Šudden' > Actually, the way those collations work is that on first pass, S and Š compare equal, but if two words on first pass compare equal, then effectively a second pass take place, and on the second pass, S and Š compare with an order (I thought I remembers there even being some cases that needed a third pass).
-- Richard Damon _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
