You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I don't know for Cockroach DB, but I know that PostgreSQL supports collations. This is nice feature that replaces existing extensions like citext in order to have case insensitive columns (like an email).
I think we could have a collation= property to Varchar/Text columns. Collations can be created by a raw migration, but any better system would be welcome. Of course it could work with any collation, not only case insensitive.
Currently I implemented this using a Varchar subclass, as a proof of concept:
Hello,
I don't know for Cockroach DB, but I know that PostgreSQL supports collations. This is nice feature that replaces existing extensions like
citext
in order to have case insensitive columns (like an email).I think we could have a
collation=
property toVarchar
/Text
columns. Collations can be created by a raw migration, but any better system would be welcome. Of course it could work with any collation, not only case insensitive.Currently I implemented this using a
Varchar
subclass, as a proof of concept:And I added this collation using a migration:
I'm new to Piccolo and I'm discovering the code base, their might be a better way of doing this.
The text was updated successfully, but these errors were encountered: