-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 02/04/12 14:34, Simon Slavin wrote: > I wonder whether it respects languages.
A German user living in France has some Swedish names in their list to be sorted. Do you use Swedish sort order, German sort order, German name order or French order? There is a Unicode Collation Algorithm that tries to help: http://unicode.org/reports/tr10/ Something you may want to consider is to transliterate the text into the closest ASCII sounds and then sort on that. It will help when you have multiple languages represented, some text missing accents etc. If you search for "unidecode" you'll find a toolkit for doing just that in various languages. The original was written by Sean Burke and the thinking is documented here: http://interglacial.com/~sburke/tpj/as_html/tpj22.html That site appears dead so the wayback machine helps: http://web.archive.org/web/20091014161106/http://interglacial.com/~sburke/tpj/as_html/tpj22.html Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk96ODwACgkQmOOfHg372QTOOgCZAQ95J0sYZZYU5LkmxA2+WtoV 8VQAoMy1FH/wiuaekSIdyspXIGt1pc+1 =ehka -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
