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. |