Skip to content

Case

SQLColumnConstraintAlgorithm.collate(name:)

A COLLATE column constraint, specifying a text collation.
case collate(name: any SQLExpression)

Discussion

This is considered an “informative” constraint, describing the behavior of the column’s data, rather than a validation constraint limiting the data itself. In most SQL dialects, it is only valid for columns of textual data type.

This is a column-only data constraint; it cannot be specified at the table level.