drizzle-team / drizzle-team/drizzle-orm

[FEATURE]: Support setting collation of columns

Open
#638 23 comments 64 reactions 0 assignees View on GitHub
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

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.