| 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 5.56 years ago |
Created: |
2019-11-06 10:18:30 5.65 years ago |
| 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. | ||||