drizzle-team / drizzle-team/drizzle-orm
[FEATURE]: Support setting collation of columns
Open
db/mysql
db/postgres
drizzle/kit
enhancement
- Dominant language
- TypeScript
- Stars
- 35.8k
- Forks
- 1.6k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 4
Description
### Describe want to want
Another fun Postgres feature! Let's say you're using [fractional indexing](https://observablehq.com/@dgreensp/implementing-fractional-indexing) and want to sort strings in a particular way that has nothing to do with their ordering in English or any other language, but with how they'd compare by codepoints, like ASCII strings. You could use `COLLATE "C"` to do that.
This would be an addition to the `text()` type in the schema builder.
Contributor guide
Assessment
This issue has not been assessed yet.