dotnet / dotnet/EntityFramework.Docs

Add SQLite docs on collations/case-insensitivity

Open
#3,840 0 comments 1 reaction 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.