lemon24 / reader

A Python feed reader library.
https://reader.readthedocs.io
BSD 3-Clause "New" or "Revised" License
438 stars 36 forks source link

Feed title sorting broken for Unicode #250

Open lemon24 opened 3 years ago

lemon24 commented 3 years ago

... because SQLite only sorts ASCII by default.

The Python bindings expose create_collation(), so it should be possible to sort in some other way (this may break indexes, though).

Alternatively, if we implement a title sort that drops prefixes ("the" etc.), maybe we can handle Unicode there.

AFAIK, the only place where we need to sort by Unicode is the feed title.