SQLite Forum

Natural sort order
Login
> simple accent folding so 'a', 'á' and 'À' are with 'A'

Just be aware that in some languages it is not (always) correct to simply "fold" (i.e. ignore) accents when sorting (for example, in Swedish – apparently – the letters 'å', 'ä', and 'ö' are considered distinct letters, not 'a' and 'o' with diacritics). See [this answer](https://ux.stackexchange.com/a/115620/57088) on StackExchange or [Diacritic](https://en.wikipedia.org/wiki/Diacritic#Diacritics_that_do_not_produce_new_letters) on Wikipedia.