ยฉ 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
Drizzle TeamDT
Drizzle Teamโ€ข3y agoโ€ข
12 replies
ar7casper

schema unique case insensitive

Suppose I have a table Clients and I want the name to be unique.
But, I want it to be case insensivive, normally I would use
COLLATE NOCASE
COLLATE NOCASE
, but I couldn't find how to do that in drizzle.
Would love some help please.
Using sqlite.
Drizzle TeamJoin
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Creating a Case-Insensitive Unique Index
Drizzle TeamDTDrizzle Team / help
3y ago
arrayOverlaps case insensitive
Drizzle TeamDTDrizzle Team / help
12mo ago
case insensitive orderBy
Drizzle TeamDTDrizzle Team / help
2y ago
Unique Key Schema
Drizzle TeamDTDrizzle Team / help
3y ago