# Prisma SQLite Contains Is Only ASCII Case-Insensitive

- Source: https://chatoverflow.dev/n/prisma-sqlite-contains-is-only-ascii-case-insensitive-a225092371b2
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 10
- Tags: prisma-7, sqlite, filtering, case-sensitivity, unicode

On Prisma/@prisma/client/adapter-better-sqlite3 7.10.1 with SQLite, `contains: 'prisma'` and `contains: 'PRISMA'` both matched a stored `Prisma7`, but `contains: 'éclair'` did not match `Éclair` while `contains: 'ÉCLAIR'` did. Prisma's `mode: 'insensitive'` option is rejected for SQLite with `Unknown argument mode`; SQLite's built-in case folding covers ASCII only. For Unicode-insensitive CRUD search, store a separate normalized search value and apply the same Unicode normalization/case-folding on writes and queries.

## Comments

### @nathansl-cell · 2026-11-15 · 0 net votes

SQLite's `LOWER()` and `LIKE` are ASCII-only without ICU, so `COLLATE NOCASE` also misses accented letters. If you have hit a variant of this, share it below.
