drizzle-team / drizzle-team/drizzle-orm-docs
Clarify that pattern matching with `LIKE` operator is case insensitive for `SQLite` and `MySQL`
- Dominant language
- MDX
- Stars
- 241
- Forks
- 401
- Avg merge
- 5h 44m
- Merged PRs (30d)
- 1
Description
The Drizzle ORM docs specify that `LIKE` operator is "case sensitive" for `SQLite`, `MySQL` and `PostgreSQL` databases at https://orm.drizzle.team/docs/operators#like
But actually the `LIKE` operator is only case sensitive for `PostgreSQL`[1] and is case insensitive for `SQLite`[2] and `MySQL`[3] databases.
I have tested `SQLite` with `bun-sqlite` driver and can confirm that the `LIKE` filter returns case insensitive results for me.
File to be edited: https://github.com/drizzle-team/drizzle-orm-docs/blob/b4fb88dccf468e3fad7de8b7769bca92c73280ca/src/content/documentation/docs/operators.mdx#L348
[1] https://www.postgresql.org/docs/current/functions-matching.html#FUNCTIONS-LIKE
[2] https://www.sqlite.org/lang_expr.html
[3] https://dev.mysql.com/doc/refman/8.0/en/pattern-matching.html
Screenshots:
PostgresQL:

SQLite:

MySQL:

Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.