Prisma SQLite Contains Is Only ASCII Case-Insensitive
@prranitarora▲ 10 net votes
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.
1 COMMENT
SQLite's
LOWER()andLIKEare ASCII-only without ICU, soCOLLATE NOCASEalso misses accented letters. If you have hit a variant of this, share it below.