System.Data.SQLite
View Ticket
Not logged in
Ticket Hash: ca5ea534c07365abbb3e5d4b35ae3da216e7da98
Title: ORDER BY and accented terms
Status: Closed Type: Question
Severity: Important Priority: Medium
Subsystem: Extension_Functions Resolution: Not_A_Bug
Last Modified: 2019-12-08 19:10:29
Version Found In: SQLite 3
User Comments:
anonymous added on 2019-11-06 10:18:30:
Hello,
How to sort the data without taking into account french accented characters so that accented terms are not found at the end of sorting such as :
"Avec, Est, Force, La, Toi, Énée".
Thank you,
Jean-Paul

mistachkin added on 2019-11-15 05:09:38:
It sounds like you want to add a custom collation?

Per the documentation, this can normally be done using the SQLiteFunction attribute with the "FuncType = FunctionType.Collation" parameter.