Nicolas Williams <nicolas.willi...@sun.com> wrote: > IMO you'll have two types of text to sort: a) generic text (e.g., > proper names), b) localized text (e.g., message catalogs). For (a) > you'll want > to pick a collation, _any_ collation.
Actually, you may want to choose a collation familiar to your application's user. After all, she's the one looking at the list of names, the one you have to convince the list is in fact sorted. E.g. Windows has the concept of default locale and sort order, chosen by the user (Control Panel | Regional and Language Options). I imagine other operating systems provide something similar. You wouldn't normally want to build indexes using this collation though, as it can change at any time (in fact, with multiple users sharing the same database, you may end up sorting the same data in two different ways at the same time). It's only good for sorting on the fly. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
