dotnet / dotnet/EntityFramework.Docs
Add SQLite docs on collations/case-insensitivity
Open
area-sqlite
- Dominant language
- Mermaid
- Stars
- 1.7k
- Forks
- 2k
- Avg merge
- 7d 23h
- Merged PRs (30d)
- 16
Description
For collations and case sensitivity, we have [these docs](https://docs.microsoft.com/en-us/dotnet/standard/data/sqlite/collation#custom-collation) for Microsoft.Data.SQLite. These docs show how to use the COLLATE operator, but not creating a column with a collation (which I think is the preferred way to do things, allowing index usage?).
Apart from that, we may want to have a section in the EF Core SQLite provider docs, guiding people specifically how to do case-insensitivity (see e.g. https://github.com/dotnet/efcore/issues/8033#issuecomment-1110757159).
Contributor guide
Assessment
This issue has not been assessed yet.